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:
- 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.
- Scroll down and expand on the Group section and find the field called PageName and enter the field value of the group name
- 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
Thank you!!
will this work if you only have 1 tab?
Sorry for the slow response, yes it should work.
Thank you…. It easy but important
Thank you! This helped!
Thank you Steve, that did the trick.