SSRS 2008 exported reports excel sheet tab name issue.

• pal.jitendra052

  SSC Enthusiast

  Points: 116

  More actions

  November 22, 2015 at 6:05 am

  #302445

  Hi, I am working on SSRS 2008. We have very large data to export in the excel sheet, so we are exporting it in multiple tabs. Issue is when we are exporting data in multiple tabs, tab names are coming as sheet1, sheet2 and sheet3. But we want report names in place of sheet1, sheet2 and sheet3.

  SSRS 2008 R2 has PageName property to do this but is there any alternative way to rename tab names as per report names, as we do not have PageName property in SSRS 2008?

• MMartin1

  One Orange Chip

  Points: 27799

  More actions

  November 23, 2015 at 11:49 am

  #1841812

  Are you referring to exporting the data in a SSRS report to Excel ? OR are you referring to a report subscription ?

  Please see if the below link helps you ...

  https://social.msdn.microsoft.com/Forums/sqlserver/en-US/8dc0ab39-5a4e-4a24-81bc-1e36bd779df5/ssrs-report-exporting-to-excel-how-to-change-sheet-name-as-report-name-?forum=sqlreportingservices

  Also you did not mention how you are exporting the one data set into multiple tabs.

  ----------------------------------------------------