search cancel

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

book

Article ID: 111109

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

 The report error received in Jaspersoft is:

Crosstab bucket/measure limit (100,000) exceeded

Resolution

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