Color Conditioning on Field

[newbie0423]

Hello,
I have a field that needs to have two conditions met. I was wondering if this could be done. below is the formula I'm using. I am getting a message a boolean is required. How should I write this formula? I am using Crystal XI

if{v_SAR_CR_Times_FromPg20.PTOutRoom}<{v_SAR_CR_Times_FromPg20.PTInRoom} then
crRed
else
crNoColor
and
if {v_SAR_CR_Times_FromPg20.PTOutRoom}<{v_SAR_CR_Times_FromPg20.ProcEnd}then
crRed
else
crNoColor

 

[PeterDimitrov]

try this:

if{v_SAR_CR_Times_FromPg20.PTOutRoom}<{v_SAR_CR_Times_FromPg20.PTInRoom} AND {v_SAR_CR_Times_FromPg20.PTOutRoom}<{v_SAR_CR_Times_FromPg20.ProcEnd} then
crRed
else
crNoColor

http://www.R-Tag.com

Viewer and Scheduler for Crystal reports and SSRS.

 

[newbie0423]

Thanks Peter, it worked I just changed the AND operator and used OR.

Thanks a bunch!