COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: satya0320 on 09 Nov 2011 02:59:24 AM

Title: how to limit list column body value in cognos report studio
Post by: satya0320 on 09 Nov 2011 02:59:24 AM
 Hi All.,

how to limit list column body in cognos report studio, i have 3 data item values displaying in the report list column body ,need to limit it to 2rows.



Venkat B
Title: Re: how to limit list column body value in cognos report studio
Post by: HalfBloodPrince on 09 Nov 2011 04:25:10 AM
Not understood properly , but try this.
Select List ->Rows Per Page->2 (whatever rows u want on page)
Thanks
Title: Re: how to limit list column body value in cognos report studio
Post by: blom0344 on 09 Nov 2011 10:39:33 AM
A strange requirement.. Do you want to randomly display just 2 instead of 3 or more dataitems? And why?
You could create a summary filter like  count(distinct [somedataitem]) = 2