Value expression error: "[BC30456] 'RdlObjectModel' is not a member of 'Reporting Services'

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 you copy/paste an expression containing "Cstr()". It gets a full name that does not resolve correctly.

Fortunately this is easy to fix, even if you have a ton of such expressions in your report. --Go to View > Code Do a find for "RdlObjectModel" or "Cstr". You are looking for something like this:

Microsoft.ReportingServices.RdlObjectModel.ExpressionParser.VBFunctions.Cstr([your expression here])

-Remove everything from "Microsoft" to "Cstr" so it looks like this:

Cstr([your expression here])

-Save. You have essentially undone what Reporting services so "helpfully" tried to do when you copied/pasted the expresion in the first place.

I have just had a similar issue but it was with another conversion function - CDEC. My guess is that similar issues would occur using any function in the Conversion group and probably others.

I had figured it out myself and removed the Microsoft.ReportingServices.RdlObjectModel.ExpressionParser.VBFunctions. that the stupid editor added. Evidently, it adds fully qualified stupid dotNET notation when copying any other object.

Unfortunately, those jerks at Microsoft have marked this bug as WILL NEVER FIX (like most Microsoft bugs).