error while executing report

  • i need to solve this error

    [rsCompilerErrorInExpression] The ToolTip expression for the tablix ‘Tablix1’ contains an error: [BC30037] Character is not valid.

    any help

  • Have you checked the tooltip property on tablix1?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • ya there was some expression, i removed it,but now i am getting another error

    the property 'DefaultValue' of report pasrameter 'ConfigurationAnnuliuzeReturns' doesnt have the expected type

    i dont hv this parameter in report

    what to do

  • You possibly have another parameter that is dependent on that parameter.

    Or, do you have any subreports that may have that parameter?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • ok. this is

    -- Parameters internal to this proc that are derived from other parameters.

    but how to solve this error

  • The stored proc is expecting the report to pass a parameter that you are not passing. Add a parameter, then add that parameter to the proc data source.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • If the missing parameter is in your SP already. Go to the dataset properties and click Refresh Fields. This should add the additional parameter to the report. You can then give it a default value, etc. and proceed.

Viewing 7 posts - 1 through 6 (of 6 total)

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