Voysinmyhead
Voysinmyhead

Reputation: 1405

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

Stumbled on an obscure problem. Posting this because my searches of stack overflow did not find my answer. Hopefully this will help someone else.

Problem: My reporting services report will compile, but at run-time provides an error along the lines of:

[BC30456] 'RdlObjectModel' is not a member of 'Reporting Services'

This happened after I copy/pasted an entire tablix over from one report to another.
After I reversed the change and removed the tablix, it worked again.
The original report with the tablix I'm copy/pasting works fine.

Upvotes: 34

Views: 26209

Answers (4)

Aladein
Aladein

Reputation: 312

if you are copy and post report just check your «Expr» . in my case the report change the data when i posted date .

from : =CDate(Fields!BillHeaderDate.Value).ToString("yyyy/MM/dd" )

TO : =Microsoft.ReportingServices.RdlObjectModel.ExpressionParser.VBFunctions.CDate(Fields!BillHeaderDate.Value).ToString

when i fixed the right value its work .

Upvotes: 1

Jye
Jye

Reputation: 1

If anyone stumbles across this issue - i fixed this by renaming the field in my dataset from fieldname to fieldname1, then reflecting that in the fields’ expression.

Upvotes: 0

Hannover Fist
Hannover Fist

Reputation: 10880

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).

Upvotes: 5

Voysinmyhead
Voysinmyhead

Reputation: 1405

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.

Upvotes: 83

Related Questions