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.
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.