Tuesday 8 April 2014

if condition in ssrs expression

It is very simple in SSRS as well. It is IIF(<condition>, <truePart>, <falsePart>) in SSRS. You can also do nesting,  if need to test multiple conditions.
Below example will give you hint:


=IIF(Fields!col.Value="RED", "RED", iif(Fields!col.Value= "Yellow", "Yellow", "White"))

No comments:

Post a Comment