CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-tablix
Michigan Man
Michigan Man

Reputation: 101

SSRS syntax converted from visual basic syntax

How would the following be writting in SSRS syntax?

If (( Fields!Name.Value = "Completed") or ( Fields!Name.Value = "Approved") or ( Fields!Name.Value = "Denied") or ( Fields!Name.Value = "Cancelled")) Then
     Fields!Name.Value =  Fields!Name.Value
ELSE
     Fields!Name.Value = "Other"
END IF

Upvotes: 1

Views: 80

Answers (1)

Bryan
Bryan

Reputation: 17693

Assuming you want to populate a tablix cell with the values specified, and this is your dataset:

Dataset

The expression:

=IIF((Fields!Name.Value = "Completed") OR (Fields!Name.Value = "Approved") OR    
     (Fields!Name.Value = "Denied") OR (Fields!Name.Value = "Cancelled"),
     Fields!Name.Value, "Other")

Produces this result:

Result

Upvotes: 1

Related Questions