var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Compare a total to + or - $5.00
I have a report I created and I want to be able to verify a grand total to a total in our database. I need to make sure that if the amount is off by +- $5.00, that the row is in red.
I figured it would be a if then statement but I'm not sure what function could do this. I'm new to Crystal, so any help would be great.
Highlight all the objects that you want to change the colour off. Then right click . This will open the Format Editor. Go to Font and then Click on the Conditional formatting button next to the Color.
Then enter your conditional statement
If Sum (Field) <> 5 Then Red