When exporting Crosstab Report / Adhoc view in Advanced Reporting to excel it returns:
Error Message:
Crosstab bucket/measure limit (100,000) exceeded.
This error is related to the JasperReports Library property:
net.sf.jasperreports.crosstab.bucket.measure.limit
By default this property is set to 100,000 in JasperReports Server.
For On Premise Customers:
This limit is configured in jasperreports.properties file under deployed <Jasperserver>\WEB-INF\classes\ directory. However, we caution users to consider performance impact on the server when increasing the limit.
Tibco Document Reference
For SaaS Customers:
This limit cannot be increased as the JasperSoft server is a multi-tenant environment and increasing such limit can have major performance impact for others as well.
Suggestions is to redesign report to reduce the amount of buckets being generated whenever possible to avoid the limit eg. by putting in a Filter to limit the number of records generated. Or try change the format to a Table instead of Cross Tab which will not hit the crosstab bucket limit.