SSRS 2014 Excel Export size limitation

Pierre Gourven 41 Reputation points
2021-09-10T11:00:10.747+00:00

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

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,854 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,581 Reputation points
    2021-09-10T11:33:08.067+00:00

    See Export a paginated report to Microsoft Excel (Report Builder) for all supported export features and also the limitations.


  2. 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 ?

    131574-total-rows.png

    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.