I tried using switch/ iif function in ssrs report

Question

Hello i tried using both switch as well as iif function in ssrs report. I have a column(Delta) which has values and need to set image depending on column values. Below is my switch statement

=Switch(
        Fields!Delta.Value =0,"arrowzero.jpg",
        Fields!Delta.Value >0,"arrowup.jpg",
        Fields!Delta.Value <0,"arrowup.jpg",
        Fields!Delta.Value ="CNC","arrowblack.jpg"
       )

Switch statement is working for all cases except last case "CNC".

Alan Schofield Alan Schofield · Accepted Answer · 2020-09-21T14:43:18

A couple of observations that might help you fix this.

You switch statement uses the same column however the first three evaluate it numerically, the last one against a string. Is this correct?
Is the image called "arrowblack.jpg", is there a typo here?
If the last option is supposed be act like an ELSE then you can replace Fields!Delta.Value ="CNC","arrowblack.jpg" with True,"arrowblack.jpg"

I tried using switch/ iif function in ssrs report

1 Answers