reporting services - can we change the font color of a field based upon the value of another field? -
i know can change font color of field based upon value of same field follows..
=iif(fields!field-name.value<100,"red","green")
writing expression in font property of particular field.
but how can change font color of 1 field basing on field's values? possible change in way?
yes, can reference fields in expression; use value(s) in current scope.
with simple data:

and simple table:

i have set fieldvalue2 textbox have color based on expression using fieldvalue1 value:

=iif(fields!fieldvalue1.value < 100, "red", "green") which works expected:

Comments
Post a Comment