Export group name in SSRS 2008 to worksheet tab name in excel

Recently, I tried to name a worksheet tab in excel from each group in SQL Reporting Services 2008.  I found that the group name needs to be entered into the tablix member group called “PageName”. The first screenshot shows the result, notice each worksheet tab coincides with the group name.

Here’s how to do it:

1. After building your group report, click on the group name (Row Groups) in the bottom left of your screen, then go to the properties window.  If it’s not displaying like in the screenshot you can choose F4 or choose view>>properties window.  In the properties window, it should display “Tablix Member”.  It should not display “Tablix”, you might be at the properties of the whole report.
2. Scroll down and expand on the Group section and find the field called PageName and enter the field value of the group name
3. Try viewing the report then exporting it to excel to verify

Here are some websites to try if this didn’t help

http://reportingservicestnt.blogspot.in/2010/10/exporting-to-excel-and-renaming-sheets_26.html

http://blogs.msdn.com/b/robertbruckner/archive/2010/05/16/report-design-naming-excel-worksheets.aspx

http://msdn.microsoft.com/en-us/library/dd255234.aspx#WorksheetTabNames