Sunday, July 2, 2023

SSRS - How to resolve RdlObjectModel is not a member of Reporting Services issue (Error BC30456)

Background: When we work on Dashboard where multiple visualization items used. sometimes, we copy and paste the existing visualization so that we dont need to create similar visualization again as it is time consuming. When we copy and paste the visualization items in RDL then expression used in the visualization will change little bit due to that report will fail with below error.

The Y expression for the chart ‘Chart10’ contains an error: [BC30456] 'RdlObjectModel' is not a member of 'ReportingServices'.

----------------------------

The definition of the report '' is invalid.

----------------------------

An error occurred during local report processing.


Solution: Below is the sample Sales report in which original expression for calculating was  =Sum(cint(Fields!SalesAmount.Value))

when we copy and paste the visualization item 


then expression changed to =Sum(Microsoft.ReportingServices.RdlObjectModel.ExpressionParser.VBFunctions.cint(Fields!SalesAmount.Value))

In order to resolve the issue, we need to remove string "Microsoft.ReportingServices.RdlObjectModel.ExpressionParser.VBFunctions." from the expression and visualization will start working.


Once we remove  "Microsoft.ReportingServices.RdlObjectModel.ExpressionParser.VBFunctions." string from expresion. it will start working.



No comments:

Post a Comment