RDLC Switch Construct - is there an Else?

Question

I have the following expression within a report:

= Switch( Fields!RATE_CODE.Value = "First", " £/Week",
          Fields!RATE_CODE.Value = "Second", " £/Day")

I've searched all over but cannot find a way to add an else or default to this expression. There doesn't seem to be any doc's on this contruct either.

Is this possible?

score 29 · Accepted Answer · edited Dec 30 '21 at 09:44

29

The Switch function returns the value associated with the first expression in a series that evaluates to true, you can use the following trick:

= Switch( Fields!RATE_CODE.Value = "First" , " £/Week",
          Fields!RATE_CODE.Value = "Second", " £/Day",
          1 = 1                            , "default value" )

edited Dec 30 '21 at 09:44

Arian

12,793
66
176
300

answered Jun 21 '12 at 10:01

Marek Grzenkowicz

17,024
9
81
111

Thanks - I'd literally discovered the same myself except I was using `""=""`. You deserve the credit though. – m.edmondson Jun 21 '12 at 10:02

RDLC Switch Construct - is there an Else?

1 Answers1