Hi Guys,
Below is the sample code for IIF expression in SSR Reports
Scenario:
if value is 1 then Sunday should be displayed
if value in 2 then Monday should be displayed
if value is 3 then Tuesday should be displayed.
How to achieve this...?
Solution:
Using IIF
=IIf(Fields!TarifeTipiNo.Value = 1, "Sunday", IIf(Fields!TarifeTipiNo.Value = 2, "Monday", IIf(Fields!TarifeTipiNo.Value = 3, "Tuesday", "Wednesday")))
Using Switch:
=Switch(Fields!TarifeTipiNo.Value = 1, "Sunday", Fields!TarifeTipiNo.Value = 2, "Monday", Fields!TarifeTipiNo.Value = 3, "Tuesday")
No comments:
Post a Comment