Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS report previewing error Expand / Collapse
Author
Message
Posted Friday, September 27, 2013 8:23 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:22 AM
Points: 613, Visits: 1,160
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.
Post #1499416
Posted Friday, September 27, 2013 9:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, March 20, 2014 1:53 PM
Points: 16, Visits: 366
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.
Post #1499463
Posted Monday, September 30, 2013 12:33 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:22 AM
Points: 613, Visits: 1,160
Still I cannot fix the bug. Please explain more on this, how to fix it.
Post #1499851
Posted Monday, September 30, 2013 4:15 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Monday, December 15, 2014 2:22 AM
Points: 613, Visits: 1,160
Thanks for the reply. I fixed it. The problem was with the study code used in the other report parameter query for audit code.
Post #1499916
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse