SSRS report previewing error

  • Can you help figure out for the following error messages while previewing my SSRS report. What is to be done.?

    [rsParameterReference] The Value expression for the query parameter ‘@Studycode’ refers to a non-existing report parameter ‘studycode’. Letters in the names of parameters must use the correct case.

    [rsInvalidReportParameterDependency] The report parameter ‘AuditCode’ has a DefaultValue or a ValidValue that depends on the report parameter “studycode”. Forward dependencies are not valid.

    Failed to build item 'QAStatement.rdl'.

    Thanks in advance.

  • It just means you've got mismatched capitalization for your @Studycode parameter somewhere, i.e. Studycode in one place and studycode in another. I find it's easier to just open the rdl file in a text editor and do a quick find and replace to catch any case differences.

  • Still I cannot fix the bug. Please explain more on this, how to fix it.

  • Thanks for the reply. I fixed it. The problem was with the study code used in the other report parameter query for audit code.

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

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