Active Reports Out Of Memory Excel Export

Active Reports Out Of Memory Excel Export

Posted by: pvaughn on 4 June 2020, 11:36 am EST

• 

  pvaughn

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 4 June 2020, 11:36 am EST

  We’re using the XlsExport class and our line looks like XlsExport.Export(reportDocument, exportPath)

  Ok so a little back story… we’re using AR11 and our program is set for 32bit computers (this is NOT optional). We have many clients all over the US and we CANNOT set our program to use 64bit. It’s also NOT acceptable to break apart the report into separate excel worksheets. We need the ENTIRE report on one excel worksheet.

  The report we’re trying to export to excel is about 200K DB lines long and whenever we try to export it I get an out of memory exception.

  Is it possible to export this report?

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 8 June 2020, 1:02 am EST

  Hello,

  AR11 is a legacy product now. It is out of maintenance mode now. Hence, we do not provide support for the same or no bug fixing will be done in the same. I would recommend you use the latest version of ActiveReports i.e ActiveReports 14. Please refer to the following link for more information:
  
  https://www.grapecity.com/activereports.

  In my understanding, when we run the application at 32bit, it is bound to use only 2GB of the system RAM. To export the 200k record, it is fair to take more than 2GB. You can check with the latest version of AR i.e AR14 as there are lots of memory issues between AR11 and AR14.

  If it is working in 64-bit environment, then it is design behavior.

  Thanks,
  
  Mohit