Status field color option in straight table

[#1]

Hi,

I have a Status field of the customer details Staright table.I want to change background color of the status field. Status field is set in Dimension.

ex;-

if customer status is "Active"then the display should be in active.

if Onhold then yello

if Inactive then RED

Thnaks!!

[Gysbert_Wassenaar]

Open the properties window of the straight table. Go to the Dimensions tab and click on the + in front of the Status dimension. Now click on Background Color and then click the Edit button. Now you can enter an expression to calculate the background color. Something like: if(Status='Active',lightgreen(),if(Status='On hold', yellow(), if(Status='Inactive', lightred()))).

[sushil353]

apply the condition in the background color of desired dimension:

and put if condition like:

if(Status='Active',lightgreen(),

     if(Status='On hold', yellow(),

          if(Status='Inactive', lightred())))

HTH

Sushil