Setting the maximum row 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 recipe.
How to do it...
In this recipe we will learn how to set the maximum row limit for a query. To do this, perform the following steps:
Open the report in Report Studio.
Go to Query Explorer and select the report query.
From the Properties pane, open the Maximum Rows Retrieved property.
For testing purposes, set it to 50 as shown in the following screenshot:
Run the report in HTML format.
Browse the report page by page. As soon as you hit the record count of 50 (usually on the third page), you will receive an error message saying that the query has reached the maximum row limit.
Go back to Cognos Report Studio and change the limit to the required row limit; for example, 2000.
How it works...
This option serves the same requirement...
