If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Conditional Display in Crosstab Report

Started by kalyan_y, 06 Jul 2009 03:26:28 AM

Previous topic - Next topic

kalyan_y

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.

sridharansathya

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.