An SQL statement into SSRS -

i tried incorporate following ssrs failed.

if xxx = “a” display “at”  else if xxx = “b” display “bee”  else if xxx = “c” display “car”  else display “other” 

i tried

=switch(   fields!xxx.value = "a", "at",    fields!xxx.value = "b", "bee",   fields!xxx.value = "c", "car", "other") 

you had it. every output in switch function must paired condition. make last condition evaluate true.

=switch(   fields!xxx.value = "a", "at",    fields!xxx.value = "b", "bee",   fields!xxx.value = "c", "car",    true, "other" )