Wednesday, 18 September 2013

report builder 3.0 SWTICH expression DEFAULT / ELSE

report builder 3.0 SWTICH 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 need 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.

No comments:

Post a Comment