Link to home
Start Free TrialLog in
Avatar of Dave Stone
Dave StoneFlag for United States of America

asked on

Crystal Reports 9 Field Color

Hello,
     I have a report that has a filed that I would like to color red if two other fields are 0.0. Is this an easy task?

Thank you
Avatar of Mike McCracken
Mike McCracken

Yes.

Right click the field
Click FORMAT FIELD
Click the BORDER tab
Click the FORMULA BUTTON to the right of BACKGROUND
If {Field1} = 0 AND {Field2} = 0 then
    crRed
Else
   crNoColor

Open in new window


mlmcc
Avatar of Dave Stone

ASKER

Thanks. However, I found that I need to include another field. If the other field is populated with "12345" and the other are 0 I do not want the red background. Doable?
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you.
The best!