31

I have tabbed my report in SSRS 2012 by having my page breaks based upon grouping classname and it works great. How do I change the tab names when exporting to Excel? I tried having an expression for page name =Fields!classname.Value. In doing so, it makes all 4 of my tabs equal the first page break of Sales Division.

My tabs are based upon the grouping of classname, which in returns gives me the 4 tabs: Sales Division, VRS, ClearCaptions, and IP-relay.

Lews Therin
  • 3,707
  • 2
  • 27
  • 53
user3798811
  • 493
  • 1
  • 4
  • 7

2 Answers2

57

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).
Also, be advised to set the sort order of the group expression, so the tabs are alphabetically sorted.

If you get the tablix instead of the tablix member, it will put the same tab name in every tab, followed by a (tabNum). That is exactly your current problem.

Tablix Member

MultiTabExcelFile

Stefan Steiger
  • 78,642
  • 66
  • 377
  • 442
  • 6
    This should be the accepted answer. This helped me solve the same issue and clarified the confusion of having to select the Tablix Member instead of the Tablix itself. – Lews Therin Jul 07 '16 at 15:03
  • This works for the first tablix in a report. The second tablix will use the PageName from the first tablix with a number in parentheses appended. – StackOverthrow Oct 12 '18 at 17:51
  • @TKK: You can also set the page-name to an expression, then you can get the tab's name from the database for every tab. Note that the (stupid) excel-limit for tab-names is 31 characters. – Stefan Steiger Jun 28 '19 at 09:28
1

This solution was not working for me.

I had to add group break page.

enter image description here

https://www.mssqltips.com/sqlservertip/3527/export-sql-server-reporting-services-report-data-into-multiple-excel-worksheets/

Hugues Gauthier
  • 639
  • 8
  • 18