IIF statement is pretty much easy if it is a straight forward single condition. If it is nested IIF statement (multiple conditions), it might some time takes a little time to understand and use it.
Ex: If there are 4 conditions to check then use only 3 IIF conditions.
This is an example of cell Background Color Expression in SSRS.
= IIF(Fields!Data1.Value=”Lite Turquoise”,”#CCFFFF”, (IIF(Fields!Data1.Value="Ivory","#FFFFCC", (IIF(Fields!Data1.Value=”Plum”, “#993366”, “#9999FF”)))))
Hope this article helps...
Thank you.
No comments:
Post a Comment