<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Increasing Row Limit in JasperReports Server

Published on
3,876 Points
776 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

Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Join & Write a Comment

Basic Overview of office 365 user portal
I've published three five-minute Experts Exchange video Micro Tutorials that describe terrific features in an excellent, free PDF product called PDF-XChange Editor: How to rotate pages in a PDF with free software (https://www.experts-exchange.com…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month