question

vivekyadav0212 avatar image
vivekyadav0212 asked

Import multiple SSRS reports in one Excel Sheet

How can we import multiple SSRS reports(tabular) of a server into one excel sheet in different tabs.
ssrs-2008
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
west007 avatar image
west007 answered
Hi You gave not much input to understand what is your current setting. When a Report has more then one table, the export to excel makes for every table a new sheet. So let me assume you have many different reports. When you make one Report with all the Reports included as Subreport, the excel export should make a sheet for every subreport. Or when you make one Report with all the tables from the Reports, the export makes for every table a sheet. Take it as Hint, but i never tryed ist myself. Regards
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks west007. It is very helpful.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.