<

Increasing Row Limit in JasperReports Server

Published on
3,782 Points
682 Views
1 Endorsement
Last Modified:
Doug Walton
DBA for the site that connects you with people and information to solve problems, inspire learning and influence the future of technology.
How to increase the row limit in Jasper Server.
Sometimes I get the following error, and I wanted to explain how to fix it since I had trouble finding the solution.
net.sf.jasperreports.engine.JRRuntimeException: Crosstab bucket/measure limit (1,000,000) exceeded.

Open in new window


In the AWS supplied version of Jasper Server tomcat runs out of /usr/share/tomcat7.

The following file has several configuration settings you can change (path may be slightly different before the WEB-INF directory):
/usr/share/tomcat7/webapps/jasperserver-pro/WEB-INF/classes/jasperreports.properties

The following line is where you'll want to increase the row limit:

net.sf.jasperreports.crosstab.bucket.measure.limit=1000000
Restart tomcat after you save the file for the change to take effect.

Be careful running large reports or it'll possibly cause out of memory errors if you set the value too high.
1
Comment
Author:Doug Walton
0 Comments

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Join & Write a Comment

Watch this online video tutorial and learn the best way to reduce Outlook mailbox size using Compact Now feature of Outlook. It removes the deletes item's space from Microsoft Outlook 2016, 2013, and 2010 and compresses the PST file size. This will …
If you, like me, have a dislike for using Online Subscription anti-spam services, then this video series is for you. I have an inherent dislike of leaving decisions such as what is and what isn't spamming to other people or services for me and insis…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month