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.

Procedure

  1. On your Jazz® Reporting Service system, open the JRS_install_dir\server\conf\rs\app.properties file in a text editor.
  2. Add 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
  3. Save your changes and restart the server.