COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Vick on 12 May 2008 08:33:51 AM

Title: Restrict rows in Report Studio
Post by: Vick on 12 May 2008 08:33:51 AM
Hello,
           Is there any option in Report Studio to restrict number of rows retrieved...this can help in testing the report output while building reports in Report Studio.


Thanks,
Vick.
Title: Re: Restrict rows in Report Studio
Post by: Gopinath on 13 May 2008 04:03:56 AM
Set the Maximum Rows Retrieved Query Property (Under Query-> Properties-> Query Hints) to the desired number of rows.
Title: Re: Restrict rows in Report Studio
Post by: blom0344 on 13 May 2008 09:28:51 AM
Adding a simple filter (say for a certain high-level object) can be usefull as well..