How to get named excel sheets while exporting from SSRS

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.