I am running a report that has 40 columns and about 56,000 rows, but when it is trying to create it, it uses tons of memory and then crashes with this exception, I can't make the report any smaller, it should be possible to run this report but it isnt working.
I am able to run the query in sql query analizer with out any problems what-so-ever and it returns relitively quickly. When it do it through reporting services it takes approximately 3-6 minutes then crashes with the above error. I am trying to export to csv.
Is there a way to make it render quicker without the need to render any fancy things to make it go quicker and use less memory. By the end of the render it used up over 800 MB RAM.
You may want to try exporting to a Microsoft application like word, then export the word file which you can save a xml to CVS. If you are using the union operator in your query if it is not important to eliminate duplicates use union all. Hope this helps.
its not so much the query it is the rendering of the output by the Reporting Services, the Query only takes a couple of seconds and completes successfully.
blackdisk
Participant
1895 Points
381 Posts
Running Large Report "System Out Of Memory Exception"
Apr 19, 2005 05:08 PM|LINK
Caddre
All-Star
26581 Points
5308 Posts
Re: Running Large Report "System Out Of Memory Exception"
Apr 26, 2005 06:48 PM|LINK
Gift Peddie
blackdisk
Participant
1895 Points
381 Posts
Re: Running Large Report "System Out Of Memory Exception"
Apr 26, 2005 07:00 PM|LINK
Caddre
All-Star
26581 Points
5308 Posts
Re: Running Large Report "System Out Of Memory Exception"
Apr 26, 2005 07:50 PM|LINK
Try this url for import/export to CVS code. Hope this helps.
http://www.codeproject.com/aspnet/ImportExportCSV.asp
Gift Peddie