Saturday, February 25, 2012

Change text color

Dear all,

May I know how can I change a text color if the data meet certain condition?

Thanks in advance

Levine

You can set this in the properties window.
Click on the textbox you want to change and then click in the "Color" box.. select the dropdown in that field and clickon "Expression..".

Then use a formula such as:

=IIF( Sum(Fields!Hours.Value)>=7 , "Black", "Crimson")

The expression builder can assist you with your own data fields etc.

No comments:

Post a Comment