Is it possible to have SSRS look at the value of a text box after calculating it, and then apply an expression to determine the color of the text?
More specifically, I have a lot of different text boxes that contain custom formulas to calculate percentages. Normally, I would create an IIF statement in the text color expression builder like this:
The answer is yes, if you are using a very recent version of SSRS:
=IIF(Me.Value < 0,"Red","Green")
Link to original article here
Hope that helps.