2340patel Posted June 7, 2019 Share Posted June 7, 2019 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-colAppreciate if someone can please guide. Thanks,Anjana. Link to comment Share on other sites More sharing options...
darth_fader Posted June 10, 2019 Share Posted June 10, 2019 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now