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

how to display the record in a colour by depends upon a value???

Started by everlearner, 08 Aug 2012 02:20:48 AM

Previous topic - Next topic

everlearner

Hi gurus,

in my list report i have a calculated column which has YES, NO values. now i want to display all the 'YES' records in a color.
how can i do this???
thanks in adv

LOUM

Hi everleaner:

You would use the conditional styles icon on the tool bar.

Loum

charon

im not sure, but i think the "normal" conditional style (button in the menu bar) will enable conditional formating for numbers?!
what will work for sure is creating a bool variable (variable panel), and use a syntax like [Data Item] = 'Yes' .
Then, use this variable as style variable in the property pane of your data container (list/ crosstab).
in the last step, you want to click on the "yes" (or "no") in the property panel of your nbew created variable, the panel will become green and you wil be able to format the columns/ rows or even cells as pleased.

cheerz :P

Lynn

You can use conditional formatting for anything, not just numbers. I tend to select Advanced Conditional Style and then use any expression that suits my fancy. I find conditional style easier than style variables, but I suppose it is just a matter of preference. Either approach works.