Export to Excel crashes when downloading big amount of data.

[adnan-raza]

Hey Alan,

First of all thanks for such amazing tool to use SSRS in .net core. Yet in 2019 i am unable to found any thing better.

It is working as per my need except for one thing. When exporting big amount of data (upto 500 report pages ) to excel, it crashes. Do you have any work around for that.

[alanjuden]

@adnan-raza, I would suggest running the report manually on your report server and putting a timer to it to see how long it's actually taking. If it's taking a really long time then I would probably look at doing a couple of things.

1. Attempt to optimize the report for speed improvements.
2. If the time is still really long, then I would setup the report to run as a subscription (feature of reporting services) that is emailed to the user rather than making them sit and wait on a web page to take forever to load the report.

If those options don't work for you, you could always extend the timeout for the calls into the report server.

I hope this helps.

Alan

[adnan-raza]

@alanjuden ... Thanks for replying .
The report doesn't seems to be slow, it normally opens in about 10 to 15 secs, when using SSRS report cache, it opens up in about 3 4 secs. The issues occurred while exporting the report in excel and pdf form, export to xml is working fine though.

[Tumedi]

Hi @adnan-raza did you manage to get solution for this? I am experiencing same problem maybe you can assist if you got the solution.