Strategy ONE
Results Set Row Limit
The Results Set Row Limit VLDB property is used to limit the number of rows returned from the final results set SELECT statements issued.
If the report result set exceeds the limit specified in the Result Set Row Limit, the report execution is terminated.
This property overrides the Number of report result rows setting in the Project Configuration Editor: Governing Rules category.
When the report contains a custom group, this property is applied to each element in the group. Therefore, the final result set displayed could be larger than the predefined setting. For example, if you set the Result Set Row Limit to 1,000, it means you want only 1,000 rows to be returned. Now apply this setting to each element in the custom group. If the group has three elements and each uses the maximum specified in the setting (1,000), the final report returns 3,000 rows.
The table below explains the possible values and their behavior:
| Value | Behavior |
|
0 |
Unlimited number of result rows |
|
-1 |
Use the default value from a higher level |
|
Number |
The maximum number of rows |
Levels at Which You Can Set This
Report only