Share via

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.
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,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.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.