Exporting to excel
Posted: Mon Jan 23, 2012 11:02 am
Hi,
I am currently having problems with some production code when the user is trying to render a report to export as excel. I get an out of memory exception when the report generates. I have looked at the resource manager and the private bytes get to about 1Gb before it throws the error which makes sense to me but I cannot understand why it uses so much resource. I have successfully produced some some exports and the final files are less than 50Mb. Is there way of reducing the amount of resource needed to render a report?
Chris L
I am currently having problems with some production code when the user is trying to render a report to export as excel. I get an out of memory exception when the report generates. I have looked at the resource manager and the private bytes get to about 1Gb before it throws the error which makes sense to me but I cannot understand why it uses so much resource. I have successfully produced some some exports and the final files are less than 50Mb. Is there way of reducing the amount of resource needed to render a report?
Chris L