ssrs-expression – Row Coding

Report Builder 3.0 SWITCH expression DEFAULT/ELSE

July 18, 2023 by Tarik

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 … Read more

Reporting Services Remove Time from DateTime in Expression

March 6, 2023 by Tarik

Something like this: =FormatDateTime(Now, DateFormat.ShortDate) Where “Now” can be replaced by the name of the date/time field that you’re trying to convert.) For instance, =FormatDateTime(Fields!StartDate.Value, DateFormat.ShortDate)