Limiting the number of Excel records in a report

Edit online

By default, a report exported to Microsoft Excel exports a maximum of 20,000 records. If the number of records is too large, you can set a limit of the number of records for the query to retrieve.

About this task

Note: Considerations when upgrading from 6.0.6.1:

In 6.0.6.1, if you set the query.results.excel.limit property to a certain value, after you upgrade to 7.0, this setting is preserved and the value will continue to be valid in 7.0.
In 6.0.6.1, if you did not set this property, the number of records exported is 5,000. After the upgrade to 7.0, since no value is set, the number of records exported is the default value of 20,000 records.

Procedure

On your Jazz Reporting Service system, open the JRS_install_dir\server\conf\rs\app.properties file in a text editor.
Find the query.results.excel.limit property and set a value with the limit.
For example, to limit the query to 100 records, set
```
query.results.excel.limit=100
```
To remove the limit on the number of records, set
```
query.results.excel.limit=-1
```
All records are exported when this property is set to -1.
Save your changes and restart the server.