reporting services - How to export all the reports to excel in single workbook from one folder on the report server in SSRS -
i had below requirement.
i created reports example in ssrs
sales report a, sales report b , sales report c
and deployed reports folder 'sales operations' on report server.
instead of running each report want run 3 reports in 'sales operations' folder @ once , export 3 reports in same excel workbook.
thank in advance.
is below need?
- create master report , drop several rectangles onto it.
- within each rectangle, embed report a/b/c subreport.
- open property window of rectangle , add page break each rectangle.
- when export report excel, each report should on different tabs.
Comments
Post a Comment