out of memory exception

Question

hey! I was trying to display a report with more than half a million rows in SSRS using the report designer. AN error of type

 

Out of memory exception is throw. How to increase the limit of number of rows in SSRS report designer

Answer 1

Which version of SSRS are you using?  If it is SSRS2005, since the SSRS2005 engine processes the whole report at once, it will run into resource constraints for reports having huge amount of data. In 2008, there have been quite a few scalability enhancements through on-demand procesing and it will be less likely to hit OOM exception.

http://blogs.msdn.com/robertbruckner/archive/2008/07/20/Scale-up-improvements-in-reporting-services-2008.aspx
http://blogs.msdn.com/robertbruckner/archive/2008/08/11/on-demand-report-processing-in-rs-2008.aspx

Answer 2

That is an awful lot of rows.  I generally advise people not to build reports like this.  I'm curious how useful a 500k+ row report is going to be to the consumer.  What rendering extension are you using?  OOM errors may occur in 2005 with report of this magnitude, but in general 2008 handles high memory-consumption reports a lot better.  Can you try on 2008 with the latest cumulative updates applied?

 

Thanks,

Chris