Viewing large reports

MikeD · Post by **MikeD** » Thu Jul 08, 2010 11:40 am

Is there a way to view large reports (over 300 million bytes) without getting an out-of-memory exception.

Post by **Andrew** » Thu Jul 08, 2010 2:10 pm

Hello,

Could you, please explain your issue in details.

Thank you.

MikeD · Post by **MikeD** » Thu Jul 08, 2010 2:46 pm

A report we created pulls 30k rows from the database. Each row is about 3,000 records.

We get and outofmemoryexception.

Creating 5 different reports is NOT an option. We want to create the report and then export the data to a excel spreadsheet to analyze the data. Our customers really want this feature.

Post by **Jan** » Fri Jul 09, 2010 5:48 am

Hello,

Try to use ReportCacheMode property of report. This property available from report designer. Set it to true. Also you will be have problem with export to Excel. Export to Excel does not support cache mode and require some amount of memory. Also MS Excel have some restrictions in amount of rows. As i remember correctly MS Excel 2003 allow only 64k rows. MS Excel 2007-2010 allow aorund 1 m rows. In your case you will have 30k*3000 = 90 000 000 rows. Its to big.

Thank you.