Abey
Abey

Reputation: 165

Conditionally change font color - crystal reports

I am trying to make a text box conditionally invisible by tying it to the value of adjacent revenue column.. I tried using the formula - if command.revenue > 5000 then crgreen else crnocolor , in the font formula editor but it is not working. Need help in doing this the right way. Thanks

Upvotes: 1

Views: 1306

Answers (1)

You should conditionally suppress the value instead of making it invisible; set the suppression formula for the textbox to

Command.Revenue > 5000

Upvotes: 1

Related Questions