Tuesday, 28 January 2014

In SSRS, how to change the Background colour depend on Expr value


Sometimes we get requirements to highlight a specific cell of a table depend on the final value. In my example below, I calculate the value falls under “Weeks” column and need to make the cell Bodycolour to Red if the value is greater than 10. Here are the steps.

Go to Text Box properties and use the IIF condition.

Ex:

=IIF((<<Expr>>) >=10 ,”Name(code) of the colour if the condition is TRUE”, “Name(code) of the colour if the condition is FALSE”)


No comments:

Post a Comment