SSRS IIF Conditions

IIF Condition with two Field Values 

Problem:
Getting a string output according to the two DataFields

Example :

DataField 1            DataField2                   Output
(IsComplete)        (IsApproved)

    True                      True               =       "Completed"    
    False                      False              =       "Pending"
    True                      False              =       "Rejected"


Solution:

Use the expression as:

=iif((Fields!IsCompleted.Value = "True") AND (Fields!IsApproved.Value = "True"), "Completed","") &
iif((Fields!IsCompleted.Value = "False") AND (Fields!IsApproved.Value = "False"), "Pending","")&
iif((Fields!IsCompleted.Value = "True") AND (Fields!IsApproved.Value = "False"), "Rejected","")


----------------------------------------------Regards Shashika -----------------------------------------------------