When exporting Crosstab Report / Adhov view in Advanced Reporting to excel it returns;
Crosstab bucket/measure limit (100,000) exceeded.
CA PPM SaaS and CA PPM On Premise
This error is related to the JasperReports Library property:
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.
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 corsstab bucket limit.
JasperSoft Community reference: