Conditional expression

Hi BI_group,

In Reporting Services, we can use switch function to return the value associated with the first expression in a series that evaluates to true. So in your scenario, if you want to display different color based on multiple groups, we can use the expression below in the BackgroundColor property of the cell which you want to highlight color .

=switch(Fields!ProductID.Value = 1 And Hour(Now()) >= 1 And Hour(Now()) <=9 And fields!col1.Value>1,"Red",
        Fields!ProductID.Value = 2 And Hour(Now()) >= 1 And Hour(Now()) <=9 And fields!col1.Value>1,"Yellow", 
        Fields!ProductID.Value = 3 And Hour(Now()) >= 1 And Hour(Now()) <=9 And fields!col1.Value>1,"Green")

For more information about switch function, please refer to the following link:

http://www.bidn.com/blogs/ChrisAlbrektson/bidn-blog/1478/ssrs-switch-function-examples



If you have any more questions, please feel free to ask.



Thanks,

Katherine Xiong

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.

Thanks for helping make community forums a great place.