I am working on crosstab where there are number of row groups(10) , some column group(1) and some measeures(10).The cross tab is working fine when i limit the number of rows to 5000.But as i am increasing the number of rows to 10000 it is throughing java heap space error .I have tried decreasing the number of measure and row group.but still the same problem exist when the number of column is high.
I have tried setting the report virtualier in ireport with setting block size :100 min. grow count 100 and maximum size of paged in cache 100. In that case it is throwing following error .
JRGzipVirtualizer Size: 100
Error filling print... java.lang.OutOfMemoryError: Java heap space null
java.lang.OutOfMemoryError: Java heap space
Can anybody please suggest me something about how to work with large dataset(75000 + rows) in crosstab or where i may be going wrong.
The error code thrown is
Thanks for reading