Error in text box

  • I am giving my header in test box something like below:

    ="Benefit Reduction Due to Age" &" For "& Parameters!Carrier.Value(0) & " for the month of " & Parameters!Month.Label & " " &Parameters!Year.Value

    And I am getting error something like below.I dont know whats wrong in the expression.

    Warning1[rsRuntimeErrorInExpression] The Value expression for the textrun ‘textbox5.Paragraphs[0].TextRuns[0]’ contains an error: Operator '&' is not defined for string "Benefit Reduction Due to Age F" and type 'Object()'.

  • komal145 (8/16/2012)


    I am giving my header in test box something like below:

    ="Benefit Reduction Due to Age" &" For "& Parameters!Carrier.Value(0) & " for the month of " & Parameters!Month.Label & " " &Parameters!Year.Value

    And I am getting error something like below.I dont know whats wrong in the expression.

    Warning1[rsRuntimeErrorInExpression] The Value expression for the textrun ‘textbox5.Paragraphs[0].TextRuns[0]’ contains an error: Operator '&' is not defined for string "Benefit Reduction Due to Age F" and type 'Object()'.

    Looks to me that you are trying to concatenate a string and non-string value together and SSRS doesn't like that.

  • I think your problem might be Parameters!Carrier.Value(0).

    Parameters!Carrier.Value(0) indicates that you want the first value in a multi select parameter. I am wondering how you know that you want the first value every time? If it is not a multi select then drop the (0)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply