Export Jaspersoft Dashboard Error

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Export Dashboard error

Getting an error when I try to export the dashboard in Jaspersoft Advance Reporting in PDF or Excel.

Attached in the screenshot :

2023-06-22T12:43:32,389 ERROR AsyncJasperPrintAccessor,pool-9-thread-777:321 [] - Error during report execution net.sf.jasperreports.engine.JRRuntimeException: Crosstab bucket/measure limit (100,000) exceeded. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.checkBucketMeasureCount(BucketingService.java:988) ~[jasperreports-6.20.0.jar:6.20.0-2bc7ab61c56f459e8176eb05c7705e145cd400ad]

 

Environment

Release : 16.1.2

Resolution

The formula to calculate the crosstab bucket measures is:

(number of crosstab rows) x (number of crosstab columns) x
(number of user-defined measures + 1)

Once we reduce/limit the data (less rows) & (less columns) and export the Dashboard and it exported successfully into XL and or PDF.

 

Recommendation: We can create multiple Dashboards instead one large one and then export into desire format.