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]
|
Release : 16.1.2
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.