This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

How to add ssrs report as a new to existing excel report.

Question
0

Sign in to vote
Hi ,

I have the report which is already created in Excel.(Queries are ran through manual excel and sql queries)

Now we have a criteria to automate the report using SSRS .

To be simple can I add the ssrs report as a new sheet to existing Excel report?

We are using SQL Server 2008 Reporting Services and Excel 2007
- Edited by deepak_cool Friday, February 21, 2014 1:08 AM
Friday, February 21, 2014 1:08 AM

Answers

0

Sign in to vote
Hi,

You can convert the Excel reports running through SQL queries as SSRS report with queries as datasets and then export all reports as Excel altogether through SSRS .

Try below links for reference :

http://msdn.microsoft.com/en-us/library/dd255234.aspx

http://technet.microsoft.com/en-us/library/ms159762.aspx

sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.
- Proposed as answer by Katherine Xiong Monday, February 24, 2014 1:55 AM
- Marked as answer by Katherine Xiong Friday, February 28, 2014 10:04 AM
Friday, February 21, 2014 3:39 AM