<

Increasing Row Limit in JasperReports Server

Published on
3,674 Points
574 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Join & Write a Comment

Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month