mercredi 1 avril 2020

SSRS Switch statements for multiple conditions

I'm attempting to use a SWITCH statement in order for Report Builder to tell me the premium depending on the level of cover that's selected for this particular part of a policy.

The statement I'm using:

=SWITCH(Fields!Salon_Stock_Equipment_Cover.Value="NOTREQ", "Not Required", 
Fields!Salon_Stock_Equipment_Cover.Value="1500", "22.40", 
Fields!Salon_Stock_Equipment_Cover.Value="2500", "33.60", 
Fields!Salon_Stock_Equipment_Cover.Value="5000", "39.20")

I'm using this in Report Builder.

Aucun commentaire:

Enregistrer un commentaire