You can limit the number of rows returned on each page
or on the entire output of a report.
Reports can return large amounts of data, especially
if they lack fixed filters or required runtime selectable filters.
It can be difficult to print or view a report with thousands of rows,
and finding specific records in such a report can be challenging.
For these reasons, you might want to limit the number of rows a report
can return on a page or in total.
You can set limits for each
output level in the report.
- Select the level you want to add the record limit to from
the Level drop-down list at the top of the
design surface.
- Click the Level tab.
- Click the Record Limit button.
- Enter field information.
Edit Row Limit Window
| Field |
Description |
| Limit To |
Select this check box to limit the records returned
on the output level. |
| Rows |
Enter the maximum number of rows you want returned. The VRL_HARD configuration setting sets a hard limit on the number
of rows that can be returned in a report. Values entered in this field
that exceed the VRL_HARD limit are ignored. See Analytics Configuration Settings for information
about this and other configuration settings that can impact reports. |
| Per Page |
Select this check box to apply the record limit
to each page of the report. If this check box isn't selected, the
row limit you enter restricts the total number of rows returned in
the selected output level. |
- Click OK.