Problem while running jasper Reports with bulk data in xls

[jagadeshkb]

I am running reports which has 80000 records, I am able to produce the jprint object. But while exporting the data to XLS. I am getting the following error. java.lang.OutOfMemoryError: Java heap space at net.sf.jasperreports.engine.export.JRGridLayout.layoutGrid(JRGridLayout.java:302) at net.sf.jasperreports.engine.export.JRGridLayout.<init>(JRGridLayout.java:140) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:468) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:448) at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:208)

But I can run the report in PDF. How to overcome the issue?

Regards, Jagadesh.
 

[szaharia]

Hi,

Apparently it was caused by the amount of information per sheet. Try to reduce the number of rows per sheet using either the JRXlsAbstractExporterParameter.MAXIMUM_ROWS_PER_SHEET parameter or the net.sf.jasperreports.export.xls.max.rows.per.sheet hint property.

Hope this helps,

sanda

[pradeepp]

Hi,

I'm also having the same problem while exporting data to Excel. 
Size of data is  more than 400000 records.
I user all kinds od virtualizers to generate the file. But after 15 mins I'm getting heap space or out of memory error.
Environment:
OS: Linux: FC 9
RAM : 3GB.
App server: JBoss.

In prod environment, the data set may even large.
Help me out in  this regard.

Regards,
Pradeep. P