iReport crosstab rows limitation


Hi Guys,

Is there any rows number limitation for the crosstab?

I have a query, which returns 100k unique records.

After the report generation in the XLSX version I see 35k of them. What is more they are the last 35k records, which means after generating 65k records the crosstab somehow started displaying records from the beginning.

Experienced this problem in iReport 3.7.2 as well as in 4.5.1.

km.chaber's picture
Joined: Aug 6 2015 - 6:45am
Last seen: 4 years 1 week ago

1 Answer:


Try using JasperReports 6.1.0. I haven't experienced the error you've mentioned.

The error I've encountered is with maximum number of measures - this can be avoided by setting the following property.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 months 2 weeks ago