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