COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: johangel on 16 Jan 2009 03:40:48 AM

Title: equal values in list column body cells
Post by: johangel on 16 Jan 2009 03:40:48 AM
When all the values (not numeric) in list column body cells are equal I have to hide them by using conditional formatting.
With condition I have to use for this?
In BO it was simply "when max(body cell) = min(body cell) then 'equal' else 'not equal'
Sincerely,
J.
Title: Re: equal values in list column body cells
Post by: jshanks on 18 Jan 2009 06:41:26 PM
What if you perform a COUNT DISTINCT calculation on the column and then set a BOOLEAN render variable on the "List Column" object?  The render variable would be something like below:

COUNT( DISTINCT [column] ) > 1

When this condition evaluates to TRUE, the column will be rendered in the report output.  If it evaluates to FALSE, the column will not be rendered.
Title: Re: equal values in list column body cells
Post by: johangel on 20 Jan 2009 03:20:18 AM
It works fine, thx jshanks
johan