Search code examples
reporting-services

Reporting Services export to Excel with Multiple Worksheets

I'm currently building a MS Reporting Services Report that gets rendered to excel. I'm trying to figure out how to set up the report so that it creates multiple Worksheets (Tabs) of the data on the report. I understand that entering a page break in the report gives you a new worksheet, however, is there a way to name each tab instead of it default to (worksheet 1, worksheet 2) etc.

How can this be done?

Solution

  • As @huttelihut pointed out, this is now possible as of SQL Server 2008 R2 - Read More Here

    Prior to 2008 R2 it does't appear possible but MSDN Social has some suggested workarounds.