CODEWITHSUNDEEP
if-statementreporting-servicesswitch-statement
RangaChisi
RangaChisi

Reputation: 1

Switch Statement in SRSS

i want to have conditional formatting of the background color of a textbox. i want something like this. IF i ican use the If - else statement its still ok.

  =Switch

     (
       (First(Fields!Risk_Level.Value, "BBS_ID") = "high","Red"),
       (First(Fields!Risk_Level.Value, "BBS_ID") = "Medium","Orange"),
       (First(Fields!Risk_Level.Value, "BBS_ID") = "Low","Green")
      )

Upvotes: 0

Views: 240

Answers (1)

user359040
user359040

Reputation:

The following should work:

=Switch(
        Fields!Risk_Level.Value = "high","Red",
        Fields!Risk_Level.Value = "Medium","Orange",
        Fields!Risk_Level.Value = "Low","Green"
       )

Upvotes: 2

Related Questions