I have 2 colums in report (CR 10): ColumnA and ColumnB.

    I set background color formula for ColumnB:

         if(strcmp({ColumnA}, {ColumnB}) = 0) then

               crred

         else

               nocolor

    (it mean: if 2 columns are different value --> column B is set to red "Background" color

    case 1: columnA with value 'aaa' and columnB with value 'bbb' --> columnB is set to red in background

 

    case 2: columnA with value 'aaa' and columnB with value ' ' (one space, i get this value from DB) --> columnB is not set red in background althought 2 column is different. (I think Crystal Report can not apply formula for blank, null, event one space character)

 

     Any body have solution please tell me asap! Dose CR support formular for case 2

 

Thanks and regards,

Huynh

   The formula will not effect with value of the column is blank or null

   You can try by add formula on only one column with crred on background (this is a simple formula)

   ex: on ColumnA --> background color: add formular: crred

   This formula only effect when value of cell not blank or null. So if I use your formula:

    if isnull({columnB}) or (strcmp({columnA}, {columnB}) <> 0) then
      formula =   crred
else
      formula = crwhite

 

   It will do nothing

Test 1     Test B2

Test 2     

Test 3     

Test 4     Test B2

 

Add formular in Blackground:

if({TestTable.ColumnA} <> {TestTable.ColumnB}) then

      crred

else

      nocolor

 

Report:

 

ColumnA     ColumnB

  It effected. So I don't know why formular did not effect in field!

 

Thanks so much

Huynh