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.


  1. On your Jazz® Reporting Service system, open the JRS_install_dir\server\conf\rs\ 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
  3. Save your changes and restart the server.