Exporting SSRS Reports to Excel using RenderFormat
Part four of a four-part series of blogs

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.

  1. Exporting SSRS Reports to Excel using RenderFormat
  2. Hiding Reports Depending on ReportFormat
  3. Naming Excel Worksheets using PageName
  4. 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:

Running the report in normal view

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:

Viewing 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 Excel workbook produced

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!

This blog has 0 threads Add post