See Export a paginated report to Microsoft Excel (Report Builder) for all supported export features and also the limitations.
SSRS 2014 Excel Export size limitation
Hi everybody!
One of my customer use SSRS 2014 reports to generate Excel Exports which become larger than 30 Mo.
Which seems too big to me. I can't see clearly how he will work with Excel files as big as that.
Most of the time, he can make his export but he also regularly gets following error messages:
Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.ObjectDisposedException: Store must be open for this operation.
Is there a maximum size for Excel export?
If I don't convince my customer to change his habits, is there a way to correct this problem?
Thanks for your help
2 answers
Sort by: Most helpful
-
-
Isabellaz-1451 3,616 Reputation points
2021-09-13T09:51:09.19+00:00 Hi anonymous user ,
Olaf pasted link display that the maximum number of rows is 1048576,is it possible that your report exceed the limit ?
Best Regards,
Isabella
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.