SSRS Report Builder: Creating text color expression based on textbox value?

4
votes

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:

IIF([complex formula]<0,"RED","GREEN").

This works fine, but when you have a ton of these textboxes, each with different formulas, it would be much more efficient to just copy one standard color expression into them like this:

IIF(This.Value>0,"RED","GREEN")

Are expressions like this possible in SSRS?

2
sqlsql-servertsqlreporting-servicesreportbuilder

2 Answers

10
votes

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.

2
votes

It's not as clean, but if you need to refer to a different already calculated cell (or self reference for that matter) you can use 

=IIF(ReportItems!CellName.Value < 0,"Red","Green")

EDIT: This is actually listed in the link @Randall Mathews posted, which I didn't click until I answered.