Skip Navigation
Limiting the results of a report
Answer ID 5144   |   Last Review Date 12/19/2018

How do I limit the number of rows returned in a report?




When editing a report, you can set the number of rows returned by modifying the Record Limit.  This can be done using the steps below:

1. Edit report 

2. From the Level tab > Parameters, select Record Limit

3. Check the box to limit rows and enter the number you want

4. Enable the 'Per Page' page count if you want results limited per page.  Disable this setting if you want only one page of results.

5. Click OK

6. Save the report

7. Generate to test results

As an example of this feature, say you want to see the last 10 incidents created today.  You can enable the Record Limit and set it to return only 10 rows and disable the Per Page option.  Sorting results in descending order will return only the last 10 incidents created.