Reporting Services export to Excel with Multiple Worksheets

Asked 2009-01-20T20:10:09.113

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?

reporting-services

Edit Report

1 Answer

Group your report data based on the category that you want your sheets to be based on. Specify that you want that grouping to start a new page for every new category. Each page becomes a new worksheet in the Excel workbook.

Note: I use SQL Server 2003 and Excel 2003.

answered 2010-07-13T15:12:24.863

Reporting Services export to Excel with Multiple Worksheets

1 Answer

Your Answer