question

pgourven avatar image
0 Votes"
pgourven asked pgourven commented

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

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered pgourven commented

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


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your help Olaf!

0 Votes 0 ·
IsabellaZhangMSFT-7746 avatar image
0 Votes"
IsabellaZhangMSFT-7746 answered pgourven commented

Hi @pgourven ,

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.


total-rows.png (26.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Isabella,

Thanks for your help.
The max number of rows is 250 000.
I have 3 sheets on my Excel export and 16, 20 and 50 columns and these sheets.

The Excel Export Error Message is not explicite, but I would not have use SSRS to generate this kind of files.

0 Votes 0 ·