Top N results in Designer

You can limit the results that are displayed in a subset of the rows that are returned from an ordered set of data. Top N is the set of results at the top of an ordered set. N is the number of results to show.

The Top N Results is useful when you have several results and but do not want to show them in the report. Another scenario is when you want to highlight the top or bottom rows of a set, such as the highest numbers or lowest numbers. Use Sort to change whether the Top N is in ascending or descending order.

1. From the Designer Report, select the Top N Results icon.
2. Select the number of results to show. Specify a custom number and click Apply.
3. The number of results that are selected are displayed on the Top N Results icon. When this report is saved, the Top N Results settings are also saved.