In my SSRS report, I have a column that needs the data to be updated using a CASE / IIF / SWITCH statement expression.
Also, the data has been colored coded. So I want both the expressions to satisfy and give the output.
I used this, but not sure, if this is right....
=IIF ( Fields!ActivityDesc.Value = "EptSentDtTm" and Fields!ActivityDesc.Value = "RED", "OverDue","NULL" )
Can anyone help me out here.
Its just like using a case statement in SQL, but I am not sure, as to how implement this directly in SSRS report itself.
Can we also chose the font color. If Red then blue......
Ex: If the value = "Sky" and value_color = "Black", "Sky Blue", "White"
Appreciate any help on this.