Report Builder 3.0 SWITCH expression DEFAULT/ELSE

I am trying to display a different logo based on the users franchise number.

Parameter = UserFranNr

If the value <> 99 and <> 87, then the embedded image to display is ID0. (Embedded image names are strings.)

This works with nested IIFs but seems to be the right time/place to use SWITCH.

(There is a strong possibility that more franchises will use their own logo in future.)

=Switch 
(
Parameters!UserFranNr.Value = "99","ID99",
Parameters!UserFranNr.Value = "87","ID87",
"ID0"
)

I have not found any documentation that explains how to implement a default value using SWITCH.

Is this even possible? If so how? If not any decent alternatives? Thanks

Resources: Expression Examples (Report Builder and SSRS) Define Formula Dialog Box (Report Builder)

Plus here and other forums.

Solution 1:

There is no default clause in the SSRS Switch expression.

However, you can always modify your expression slightly:

=Switch 
(
  Parameters!UserFranNr.Value = "99","ID99",
  Parameters!UserFranNr.Value = "87","ID87",
  true, "ID0"
)

Since any time the last condition is hit it will be explicitly evaluated to true, the last row will effectively act as a default value.

I've used this in the past without issues. Other than perhaps generating frowns in people who read the expression, it works perfectly well with minimal effort.

As to whether it's sensible behaviour to have no default clause, well, that's a question for Microsoft. It certainly seems odd to me, but there you go.