ssrs-expression – Tarik Billa

Value expression error: “[BC30456] ‘RdlObjectModel’ is not a member of ‘Reporting Services’

December 10, 2023 by Tarik

Found this bug report which exactly explains the problem I had: http://connect.microsoft.com/SQLServer/feedback/details/757358/pasting-objects-with-expressions-pastes-fully-qualified-functions Summary of the above: When you copy/paste reporting services expressions from one place to another (I copied an entire tablix, with expressions in it) all the pieces of that expression get expanded to their full names. There is a bug specific to when … Read more

Report Builder 3.0 SWITCH expression DEFAULT/ELSE

May 6, 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

February 25, 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)