Is there a way to export from SSRS 2008 to a single worksheet in excel even if the SSRS report has multiple pages?

The following forum is more appropriate for your question: SQL Server Reporting Services Kalman Toth, SQL Server & Business Intelligence Training; SQL Server 2008 Training

There was a similar question being posed on the Forum previously. Here it is: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/38048911-6983-4d6f-9459-5d219e734d26 Excel renderer supports only logical page breaks. A new Excel worksheet tab is created for each explicitly defined logical page break. So, you might need to remove the Page breaks explicitly set to have the entire data in a single work sheet. Also refer: http://msdn.microsoft.com/en-us/library/ms159836.aspx [Exporting to Microsoft Excel] .. This article pretty much covers everything about Excel rendering extension for Reporting Services. Hope this helps..Chaitanya

Hi Hv Dev, It is true, just remove the report's page break, then it will display on one Excel sheet. Thanks,Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.