reporting services excel export + rename sheet

[tributek]

Hello,

I work on a report and everything is going well... excepted the export.
I have groups defined in the report so each differente groups will appear in a new sheet in Excel. Great!

Question:
I would like to know if it's posible to set up dynamicaly the name of the created sheets depending on the group name?

thanks

[tributek]

After a quick search...

Excel
Reporting Services supports rendering reports for Microsoft® Excel® 1997 and later versions. If you plan to render reports to Excel, you should be aware of some of the unique attributes of the Excel rendering extension. For example:

• Each page in the report becomes an Excel worksheet. Excel does not support the concept of page height and width, so only explicitly defined page breaks will occur.

• Reporting Services does not support specifying worksheet names.

• The rendering extension builds a tabular structure out of the report.

• Excel does not support background images for individual cells.

• Excel does not support nested containers other than lists.

• Charts are rendered as pictures, not as Excel charts.

• Rectangles are converted to groups of cells. If rectangles contain other items, the rectangle becomes a region of cells, and the border and background color of the rectangle are applied to the region of cells.

• Subreports are rendered as rectangles in the current report on the same worksheet as the parent report.