Increasing Row Limit in JasperReports Server

Published on
3,992 Points
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):

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.
Author:Doug Walton

Featured Post

Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Microsoft Office 365 Backup and Restore Solution by SysTools to export Office 365 mailbox to PST / EML file format on Windows OS. On Mac, tool backup O365 to PST / MBOX / MSG / EML / EMLX file formats. Not only this, restore option helps to import s…
In this ninth video of my Xpdf series, I discuss and demonstrate the PDFtoPPM tool, which converts a PDF file to color portable pixmap (PPM) format, grayscale portable graymap (PGM) format, or monochrome (black & white) portable bitmap (PBM) format.…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month