Browse All Articles > Increasing Row Limit in JasperReports Server
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.
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:
Be careful running large reports or it'll possibly cause out of memory errors if you set the value too high.
net.sf.jasperreports.engine.JRRuntimeException: Crosstab bucket/measure limit (1,000,000) exceeded.
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
The following line is where you'll want to increase the row limit:
Restart tomcat after you save the file for the change to take effect.
net.sf.jasperreports.crosstab.bucket .measure.l imit=10000 00
Be careful running large reports or it'll possibly cause out of memory errors if you set the value too high.
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.
Comments (0)