Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: arroju_venkat on 25 Aug 2010 01:34:09 AM

Title: How to get limited number of rows ...?
Post by: arroju_venkat on 25 Aug 2010 01:34:09 AM
Hi,


In my report, a list and a text objects are created.

If number of rows are less than or equal to 5 in the list, then the text " No .of rows are less than 5 or equal to 5 " should be displayed, else list report should be displayed.

Please let me know how to achieve it ..

Thanks in advance,
Title: Re: How to get limited number of rows ...?
Post by: Sreeni P on 25 Aug 2010 02:34:34 AM
Quote from: arroju_venkat on 25 Aug 2010 01:34:09 AM
Hi,


In my report, a list and a text objects are created.

If number of rows are less than or equal to 5 in the list, then the text " No .of rows are less than 5 or equal to 5 " should be displayed, else list report should be displayed.

Please let me know how to achieve it ..

Thanks in advance,

Insert row number calculated column in the report...and in filter write the IF/CASE condition according to ur logic ...and render that two(list/Text )object in designer conditionally....
Text only | Text with Images