ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Advanced reporting error "Crosstab bucket/measure limit (100,000) exceeded"


Article ID: 111109


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


 The report error received in Jaspersoft is:

Crosstab bucket/measure limit (100,000) exceeded


Try reducing the amount of data by following the below strategies: 

  • Set up a report with Start Date and End Date
  • Run the report quarterly vs for all time
  • Run the report with more filters to reduce the number of rows