Excel – How to assign sheet names when exporting an SSRS report to Excel

excelreporting-servicesspreadsheetsubreport

I am able to have a report with multiple subreports export to Excel with each subreport on a separate tab/sheet using the info here (placing each subreport within a Rectangle control and setting its PageBreak property to "Start").

I hoped that setting the Rectangles' PageName property would set the sheet names to what I assign there, but no – they are simply "Sheet 2", "Sheet 3", etc.

So how can I assign a specific value to the sheet names so that those values are used when the SSRS report with its subreports is exported to Excel?

UPDATE

Trying Hannover Fist's suggestion, I set the Rectangles' PageName property:

enter image description here

…but the file is still created with generic sheet names:

enter image description here

Best Answer

On My report, I selected the tablix group on Row Groups window, and I set the Group > PageName property of the group (I could even use a dataset field to name it). I succeeded on that.

In your case, is it possible to create a tablix and do the same, inserting the subreport into this main tablix? It might work.

Group page name thingy

Related Topic