CODEWITHSUNDEEP
reporting-servicesssrs-2008
Iswarya
Iswarya

Reputation: 323

Export to excel in SSRS

I have 8 reports and when exporting to excel I need all the reports in a single excel sheet. Eg: Report 1 in sheet 1 of excel Report 2 in sheet 2 of excel likeewise

Is this possible????

Please help..

Upvotes: 3

Views: 1118

Answers (1)

Steve Homer
Steve Homer

Reputation: 3932

Yes, it's a bit fiddly but you can.

If you create an empty report and populate it with sub-report components in rectangles (one for each of the eight reports you wish to generate). Set each rectange to start a new page and this should produce an eight sheet Excel workbook with one tab per report.

Upvotes: 3

Related Questions