I am exporting an Report with page breaks to excel. The challenge is that on export the records should appear in a single worksheet and not in multiple worksheet, which are created due to page breaks.
Thanks, Amit
No seperate worksheets on Exporting to Excel
Hot Topic
- how to change the order of rows in datatable randomly?
- rs drops first column in data set
- Flat Files Containing Dates
- How can I get Transactional Republishing to work?
- The database principal owns a schema...
- Error Runing a subscription on report server 2000
- Linked Server/DTC Error in WinXP Vs Win2003Server
- loading mining model error
- ?? on making a CD for SQL server express
- Inserting rows concurrently (paralellism)
SQL Server
- Flat File Destination Filename with Date ?
- Feature requests
- How to get the Columns list to the end user?
- Running Sum In View (sql server 2000)
- SQL Generation Script Missing Extended properties
- Error registering a Third Party assembly
- Error in Creating Stored Procedure from VS 2005
- Suspect Mode (no visual cue in SSMS)
- Problem with concurrent insert and update commands
- Using stored procedure or not?
No seperate worksheets on Exporting to Excel
SasaJ
When rendering to Excel, page breaks always result in new worksheet tabs. There is no way to force a page break within one worksheet.
You could use SoftArtisans OfficeWriter to do this. With this, you would define the page breaks in the Excel template file and they would be preserved when rendering to Excel:
http://officewriter.softartisans.com/officewriter-250.aspx
-Chris
nberardi
Hello,
In my opinion, ignoring page breaks when exporting to Excel would be a very useful rendering option. In our organisation, usually, PDF is used for distribution of the report as is. Excel is used a lot for analysing a bit further, and the page breaks that turn into different tabs are a big pain. I hope this option will be available in the next SP, because there seems to be no workaround except for removing the page break from the report or buying some third party tool...
Thnx!