Report Builder 3.0 SWITCH expression DEFAULT/ELSE

by

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.

Leave a Comment