Friday, 4 November 2011

SWITCH

Ok so a quick one here:

Want to change a property in SSRS based on the value of a field in your dataset/paramater?

Here's how:


=SWITCH(Fields!month_delta.Value > "SOME VALUE" , "Green",
Fields!month_delta.Value < "SOME VALUE", "Red")

This will accept all logical operators and you can add as many as you like, they resolve in order if there is any logical overlap though

Happy highlighting

:-)