Tuesday, September 24, 2013

SSRS Compile Errors


Error 3 [rsCompilerErrorInExpression] The Value expression for the textrun ‘Textbox1.Paragraphs[0].TextRuns[0]’ contains an error: [BC30277] Type character '&' does not match declared data type 'Object'.

Error 3 [rsCompilerErrorInExpression] The Value expression for the textrun ‘.Paragraphs[0].TextRuns[0]’ contains an error: [BC30277] Type character '&' does not match declared data type 'Object'.

You can get the above exception if you have a expression of
="Parameter A's : " & Parameters!ParameterA.Label& " value."

or

="Parameter A's : " & ParameterA.Label
& " value."

In the first expression & is next to parameter label and in the second one & is on the new line and in either case there is no space between the parameter label and &.

You can fix the issue by changing the expression to

="Parameter A's : " & Parameters!ParameterA.Label & " value."

or

="Parameter A's : " ParameterA.Label
 & " value." (Notice the SPACE before &)

IIS Manager Crashes on Load/Start Windows 7, IIS 7.5

IIS Manager Crashes on Start  Windows 7, IIS 7.5, Power Shell 5.1. Here is the error I got in the event viewer. IISMANAGER_CRASH IIS Ma...