Jump to content
Changes to the Jaspersoft community edition download ×

Cross tab with large number of columns fails


2340patel

Recommended Posts

We are using jasper version 6.6 we have cross tab used to output data in excel format. the number of row are 500 and columns are 68. 

With memory capacity of 2GB the process fails with out of memory. However if we reduce the number of columns to around 50 

the conversion is successful. 

We have posted the same query on stack overflow too. 

https://stackoverflow.com/questions/56484245/why-do-jasperreport-with-crosstab-output-to-excel-fails-with-large-number-of-col

Appreciate if someone can please guide. 

 

Thanks,

Anjana. 

 

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Crosstabs have to perform in memory calculations to do the binning/bucketing associated, and therefore keep the entire dataset in memory. This in turn can be very resource intensive. Your best bet is to increase the memory available to jasper, alternatively you'll need to look into A) pushing the binning/bucketing into the SQL and convert your report to do more of a SELECT * From db, standard detail band approach B) see if you can remove any buckets (column or row groups) from your crosstab.

If you do some digging, you can get a more detailed explanation of why jasper crosstab's hold data in memory, but if you think about it, it has to - it has to perform grouping/binning and any measure calculations after the data is grouped.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...