Export Jaspersoft Dashboard Error
search cancel

Export Jaspersoft Dashboard Error

book

Article ID: 269244

calendar_today

Updated On:

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 :

https://api-broadcom-ca-user.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=Z22rvt+LNmp3teS9/tx3Lg==

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.