Monday, February 10, 2014

IIF expression in SSRS reports in Ax


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