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 ...
Get IBM Cognos 10 Report Studio Cookbook - Second Edition 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.
