Export to Excel, naming of worksheet

I have a report, which when I do Export to excel it comes in excel in multiple worksheets(because I ahve page breaks in my report), Now I want to name each worksheet programatically and not manually, Any idea how we can name the worksheet through reporting services, so that on export to excel I will get the work sheets with my preferred names

This is an often requested feature however it's not supported by RS.

The only time you get a named worksheet is when you export a single page report the worksheet name will be the report name.

|||Are there any round abouts or alternatives for this?|||

Short Answer is: No.

Long Answer is:

For a solution integrated into RS UI you can write your own rendering extension in which you would have to re-code all of Microsofts logic for export to excel and extend it to apply your desired worksheet names.

For an offline solution you could just write some code that calls the web service to export your report to excel and then modifies the xls to have your desirede worksheet names

|||

I can't believe someone just happened to ask this yesterday. I've been using 2005 reporting services for nearly a year now, and TODAY for the first time (after having created hundreds of reports) I just happen to need to create a report that will run every Monday from now on that populated the worksheet tabs with identifying labels.

Looks like I'll be typing them in manually for a while.