Limiting the number of Excel records in a report
By default, a report exported to Microsoft Excel exports a maximum of 5000 records. If the number of records is too large, you can set a limit of the number of records for the query to retrieve.
- On your Jazz® Reporting Service system, open the JRS_install_dir\server\conf\rs\app.properties file in a text editor.
query.results.excel.limitproperty and set a value with the limit.For example to limit the query to 100 records, set
- Save your changes and restart the server.