all groups > sql server reporting services > may 2007 >
You're in the

sql server reporting services

group:

Exporting to Excel


Exporting to Excel Chris
5/7/2007 8:45:02 AM
sql server reporting services:
I've created several reports in VS2005 and have deployed them to my RS.
I would like each one of these reports to be a seperate worksheet in an
Excel workbook.
Is it possible to Export multiple reports as seperate worksheets to one
Excel workbook??

Thanks
--
Re: Exporting to Excel dspohn
5/7/2007 11:56:08 AM
[quoted text, click to view]

If you place all of the reports into one report this can work.

Create a new report. Place each report as a sub report in the new
report. Then make "page breaks" after each sub report. The page break
should create a new worksheet in the excel document.


D. Spohn
Re: Exporting to Excel Chris
5/7/2007 2:01:03 PM
Thank you so much!
--
Chris


[quoted text, click to view]
Re: Exporting to Excel Chris
5/8/2007 8:31:03 AM
I have a report with 3 sub reports where I placed page breaks after each one.
When I deploy to my RS and run the report it does come up with 4 pages, but
when I select Excel and then export only 3 worksheets are created instead of
4. Do you have any idea why this is happening??

Thanks in advance.
--
Chris


[quoted text, click to view]
AddThis Social Bookmark Button