How to get named excel sheets while exporting from SSRS

Question

Whenever a single page report is exported to excel, sheet in excel is named by the report name. If a report has multiple pages, the sheets are named as sheet1, sheet2,.... Is there any way to specify sheet names in SSRS 2005 ?

solution: Found this after some googleing: Changing the Sheet names in SQL Server RS Excel: QnD XSLT

Will try out and post an update if it works.

Answer 1

Necromancing, just in case all the links go dark:

1. Add a group to your report
   Also, be advised to set the sort order of the group expression here, so the tabs will be alphabetically sorted (or however you want it sorted).
   
   

   • 'Zeilengruppe' means 'Target group'
   • 'Gruppeneigenschaften' means 'Group properties'

2. Set the page break in the group properties

   • 'Seitenumbruche' means 'Page break'
   • 'Zwischen den einzelnen Instanzen einer Gruppe' means 'Between the individual instances of a group'

3. Now you need to set the PageName of the Tablix Member (group), NOT the PageName of the Tablix itselfs.
   If you got the right object, if will say "Tablix Member" (Tablix-Element in German) in the title box of the properties grid. If it's the wrong object, it will say only "table/tablix" (without member) in the property grid's title box.
   

4. Note: If you get the tablix instead of the tablix member, it will put the same tab name in every tab, followed by a (tabNum)! If that happens, you now know what the problem is.