SSRS - Changing tab name when exporting to excel

reporting-services, ssrs-2012, ssrs-grouping, ssrs-tablix

Solution

This solution was not working for me.

I had to add group break page.

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

Problem

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`.

Original source