Hello All,
I am using multiple nested IIF conditions in my SSRS reports, but getting an error. Appreciate if anyone can shread some light and fix this;
=IIF((Fields!SDtTm.Value < Fields!SchDt.Value and Fields!Canc.Value = 0, "Orange",
IIF(Fields!SchDt.Value > Now() and Fields!Canc.Value = 1, "Red",
IIF(Now() > Fields!SchDt.Value and Fields!Canc.Value = 0 and Fields!ActDesc.Value != "Completed",
"SeaGreen", "Plum")))