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