Increasing Row Limit in JasperReports Server

Doug WaltonCloud Engineer
Published:
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
1,581 Views

Comments (0)

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.

Get access with a 7-day free trial.
You Belong in the World's Smartest IT Community