THIS.column1.dynamicbackcolor= "IIF(count.name= 1

[PeriyurParthi]

i have to show the values in different colours if my below said conditions satisfies,ie if the particular cell contains a value of "ban" then it should be in some colour
if that cell contain someother value like "parthiban" , then it should show in some other colour,
{
THIS.column1.dynamicbackcolor= "IIF (table.field='parthiban', RGB(255,0,0), RGB(255,255,255))"
THIS.column2.dynamicbackcolor= "IIF(table.field='parthiban', RGB(255,0,0), RGB(255,255,255))"
this.column1.dynamicbackcolor= "iif(table.field='ban' , rgb(255,155,155),rgb(255,255,255))"
THIS.column2.dynamicbackcolor= "IIF(table.field='ban' , RGB(255,155,155),RGB(255,255,255))"
}

now the problem is only one colour is displying in grid,
pls check if errors in the above said,
regds
parthiban

 

[TomasDill]

Hi!

You require to write everything in a single expression, like below:

THIS.column1.dynamicbackcolor= "IIF (table.field='parthiban', RGB(255,0,0), iif(table.field='ban', rgb(255,155,155), RGB(255,255,255)))"



Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softservecom.com

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[ChrisRChamberlain]

PeriyurParthi

See FAQ184-624 for an alternative approach.

It allows you to colour an individual cell with a choice of 16.7 million fore and/or background colours derived from using DO CASE ... etc

Chris .