Max report data size?

Christopher Lloyd · Post by **Christopher Lloyd** » Fri Jun 17, 2011 8:28 am

Hi,

Today I have been debugging a report for a client and I am getting an out of memory exception when I render the report. The report in question does contain over 150,000 rows of data. I have used the same report with less that 100,000 rows of data without any problems.

What is data limit of the reporting tool and any ideas on how to get around this?

Chris

Post by **Ivan** » Fri Jun 17, 2011 8:59 am

Hello,

Please check the following article in our knowledgebase:

http://stimulsoft.helpserve.com/index.p ... icleid=299

Thank you.

Christopher Lloyd · Post by **Christopher Lloyd** » Fri Jun 17, 2011 9:17 am

Does that mean there is no limit on the amount of data that can be processed by the report engine?

For the record my server has 16Gb ram and splitting the report in not an option.

Chris

Post by **Andrew** » Sat Jun 18, 2011 10:34 pm

Hello,

Does that mean there is no limit on the amount of data that can be processed by the report engine?

Much of the memory is consumed for two following demands:
1. Data; most of the data is converted into datasets, which take up memory. You can only reduce the amount of data, breaking them to parts, or making more accurate data sampling without sending unnecessary information.
2. Rendered report pages. Please set the ReportCacheMode property of the report to On or Auto, and in memory only the most recent 50 pages of a report (by default) will be stored. The rest of pages will be stored in the cache on the disk. The amount of memory used for pages usually do not exceed 200 ... 300 mb.

Thank you.