Last post May 09, 2013 03:47 AM by Angie xu - MSFT
May 06, 2013 07:34 PM|neoaguil17|LINK
I have the Visual Studio 2010, and when I want to export a large excel from reporting services, finished downloading and the session dies, or when my bandwidth is low, it fails to download when there is enough information,,,,,
ie get error ...
May 07, 2013 07:10 AM|Angie xu - MSFT|LINK
The export to Excel will go to extraordinary lengths to try and maintain how your report looks.
If you have lots of different borders or colors (particularly if different formatting is determined by the data in your report) this will bloat the file.
Also check if many columns with very small and unusual sizes are created in the exported worksheet. The export does this to try and match alignment in Excel with the original report.
Try recreating your report as a basic table with no formatting or headers/footers and see . If Excel's behavior is acceptable then add each piece of formatting back until it goes away
Take a look at this link, there is an example of how to insert a page break after a certain amount of records. You'll need to add a grouping with an expression based on the RowNumber(), then page break when needed (Excel's row limit).
May 07, 2013 07:54 PM|neoaguil17|LINK
HE TRIED AGAIN, AND ONLY ME exported HAPPENS WHEN EXCEL ROWS BETWEEN 40,000 AND 50 ARE KILLED THE APPLICATION SESSION ASPNET ...
May 09, 2013 03:47 AM|Angie xu - MSFT|LINK
EXCEL ROWS BETWEEN 40,000 AND 50 ARE KILLED THE APPLICATION SESSION ASPNET
It is not so big to export 50~40000 rows in excel worksheet,
You could refer the msdn document to learn exporting to Microsoft Excel (Report Builder and SSRS), perhaps it can give some tips for you,
For further information -
Exporting to Microsoft Excel (Report Builder and SSRS)
hope it helpful to you,