Name of sheets when exporting to Excel

[acessn]

Hi.

Using SQL server 2005, Visual studio reporting.

By adding "page break at end" you can split your group to display one group item pr sheet when exporting to Excel. However, the sheets are just called Sheet1, Sheet2, Sheet3, Sheet4 etc.

Does anyone know of a way to control these names? I'd very much like to give them the name of the group item.

I've created a report which displays key data for a chain of warehouses, with each warehouse split to its own sheet in Excel. Would have been smoother if I could name the sheets...

Thanks,
Bjorn

 

[sds814]

Bjorn,

I've come across this problem in SSRS 2005 as well. After reading many posts it seems as if this is a functionality lacking in SSRS 2005. My work around was to put the name of the report as a textbox, a table, a pagebreak and then another textbox with the report name, a table, and a pagebreak.

Hopefully in SSRS 2008 it's fixed.