How can I assign sheet names when exporting an SSRS report to Excel?

1
votes

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

3
excelreporting-servicesspreadsheetsubreport

3 Answers

5
votes

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

2
votes

I usually put the subreport in a Rectangle and then give the Rectangle a Page Name.

enter image description here

1
votes

I think if you set the "PageName" in the tablix in the sub-reports it should show correctly.