java heap space error with crosstab

[cjasper]

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 
    at java.util.HashMap.(HashMap.java:209) 
    at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService$BucketListMap.(BucketingService.java:752)

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

java.util.HashMap.(HashMap.java:209) 
    at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService$BucketListMap.(BucketingService.java:752)

 

Thanks for reading

 

[ajinkya_c]

If your problem related to Java heap Space then you can resolve it by increasing Java iinitial memory pool and other option in Apache tomcat java configuration.

[cjasper]

i have tried increasing the heap space and bucket limit both.no result.

Do you know how can i check the number of buckets generated. and what can i do to decrease the number of buckets.

Thanks for replying