Exporting Groups to Excel

I have a group set up woth page breaks at the end. When I export it to Excel
it generates a separate sheet (tab) for each page. Is there a way to get it
to export into one sheet, with page breaks in the correct locations?
--
-MTThere appears to be no way around this if <PageBreakAtEnd> is true when
exporting to Excel. When a report is exported to Excel, each page in the
report becomes a worksheet (and you can't name the worksheets either).
--
Adrian M.
MCP
"MT" <MT@.discussions.microsoft.com> wrote in message
news:7552EDA9-F6F9-4008-B902-8A8FA5FFC1C6@.microsoft.com...
>I have a group set up woth page breaks at the end. When I export it to
>Excel
> it generates a separate sheet (tab) for each page. Is there a way to get
> it
> to export into one sheet, with page breaks in the correct locations?
> --
> -MTsql

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.

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.

Export to excel - table headers disappear

Hi All,

When I export a multi page report (page breaks are set at the end of each group, say product group in a sales report) to excel table header dissapear. so I dont see column headings in XL.

When viewed via web browser everything is fine.

any ideas?

Thanks

Sonny

What is the intention to post your question on SQL Server Forum. Is it using SQL Server Reporting service.

What function/logic are you using to export from WEB to Excel?

|||It sounds very much like you're viewing a Reporting Services report.

When you've exported to Excel, are the column headers there at all, or simply not repeated on each page? If it's the latter, check the Page Setup information (in Excel), to find out what gets repeated.

Good luck.

Rob|||

thanks

you are right I'm in the wrong forum. this is reporting services issue

sonny