BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
SQL Server Reporting Services 2008 R2 includes (among many other features) the ability to detect a report's rendering format, together with a facility for naming report pages. You can combine these two features to create Excel workbooks with individually named worksheets for each member of a group, as shown in this blog.
- Exporting SSRS Reports to Excel using RenderFormat
- Hiding Reports Depending on ReportFormat
- Naming Excel Worksheets using PageName
- Testing the Final Report including SSRS gauges (this blog)
Posted by Andy Brown on 25 July 2011
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Testing the Final Report
Having done the hard work, it's time to test your report!
Previewing the Report in Anything but Excel
When you preview your report, you should see this:

There's no sign of the Excel part of the report. This is because the RenderFormat.Name is EXCEL, so the Hidden property of this report is set to True.
Previewing the Report in Excel
However, it's a different story when you choose to view the report in Excel:

When you choose to view the report in Excel, using the toolbar as shown here, you'll get an Excel workbook.
In the case above, after choosing a file name for your new Excel workbook, you'll be able to open it in Excel:

The films of the first director are shown here (immediately following the cover sheet). The page break before each group member ensures a new worksheet is created for each director, and the PageName property ensures unique worksheet names.
Awesome!
- Exporting SSRS Reports to Excel using RenderFormat
- Hiding Reports Depending on ReportFormat
- Naming Excel Worksheets using PageName
- Testing the Final Report including SSRS gauges (this blog)