Setting maximum rows limit
This is similar to the previous recipe. Instead of setting any limit for query execution time, here we will set a restriction on the number of rows returned by the query.
Getting ready
We will use the report created in the previous recipe for this.
How to do it...
- Open the report in Report Studio.
- Go to Query Explorer and select the report query.
- From the Properties pane, open Maximum Rows Retrieved property.
- For testing purposes, set it to 50.
- Run the report in HTML format.
- Browse the report page by page. As soon as you hit the record count of 50 (usually on third page), you will receive an error message saying that the query ...
Get IBM Cognos 8 Report Studio Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
