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.
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):
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.
Be careful running large reports or it'll possibly cause out of memory errors if you set the value too high.