COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: kalyan_y on 06 Jul 2009 03:26:28 AM

Title: Conditional Display in Crosstab Report
Post by: kalyan_y on 06 Jul 2009 03:26:28 AM
Hi,
I need to apply conditional style on a column which has numeric values. If the column value is a decimal then display the value in some color, else display in another color.

Can anyone help me with this.
Title: Re: Conditional Display in Crosstab Report
Post by: sridharansathya on 06 Jul 2009 04:35:04 AM
Hi,

I hope you can pull another empty data item and drag that measure you have previously included in the query item .
apply the aggregate property for the dataitem to none and
use the instr function INSTR(MEASURE,'.').It will let u kno whether this is a decimal
or an integer

then apply the conditional var.....

Thanks,
Sathya.