[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1743
  • Last Modified:

SSRS 2005 - Getting Error -[rsInvalidReportParameterDependency] Forward dependencies are not valid.

I have a summary report that I want to jump to another report based on the selection from the first report.  I setup a parameter for the second report , but when I run either report now I get the foloowing message"[rsInvalidReportParameterDependency] Forward dependencies are not valid."  So basically I have a Summary Report, I want to link from the summary lines to another report that contains the details via a parameter.
0
knamc
Asked:
knamc
  • 7
  • 6
1 Solution
 
jgvCommented:
The way your question reads is that you have created 2 seperate reports; one to show a summary and another to show details (correct, right?). What have you done on the summary report so far to launch the details report (with parameters)? Have you setup a Hyperlink Action and filled in the Jump to report section? How did you fill in the parameter values?
0
 
knamcAuthor Commented:
Yes I set up a hyperlink action to jump to the report, and set the parameter to the field from the summary report.  I have the parameter setup as a query of distinct values.
0
 
jgvCommented:
The error you are getting is kind of strange for this situation. First thing is to make sure that the error is not being caused by something other than the report linking. Can you verify that the summary report works ok on it's own (remove the "Jump to report" linking and run it). Then run the detail report on it's own to make sure it doesn't have any issues. After this we can add the report link back in.
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
knamcAuthor Commented:
Both reports run fine seperately, I removed the parameter.
0
 
jgvCommented:
When you say "I removed the parameter", what exactly did you do? Did you remove the "Jump to report" link? Did you leave the "Jump to report" link but take out the parameter you had setup to pass to the detail report? Did you remove a parameter from the dataset queries? It's difficult to help troubleshoot something without having a baseline.

The reports should be setup to run individually (ie: as if they were never going to be linked). The detail report should still have a parameter setup that you would fill in manually when the detail report is run on it's own. Is this how they are setup at this point?
0
 
knamcAuthor Commented:
Yes the report are set to run individually,  they are not linked and the parameter is only present on the detail report now
0
 
jgvCommented:
Ok. Add the Jump to report hyperlink back with the parameter filled in. Then take a screenshot so I can see how you have it setup. Don't do anything else other than fill in the hyperlink data.

Also, where are you placing the Jump to report link? Is this in a table? What section of the table?
0
 
knamcAuthor Commented:
Also, where are you placing the Jump to report link? Is this in a table? What section of the table?  

It is on the textbox property for the OperatingSystemVersion from the summary report.

Screen Shot attached
ScreenShots.doc
0
 
knamcAuthor Commented:
I have it working correctly now.  But now when I choose the OperatingSystemVersion from the summary is passes the parameter, which is what it should do but it has the values on the detail report Collapsed??  I looked at the properties and the Visibility is 'Expanded"??
0
 
knamcAuthor Commented:
Also once you select the detail you want the user can not Use the back button to return to summary,  should this be a field on the detail report that has jump to Report set back to the Summary report?

Just to clarify I am very new to Reporting Services and trying to get up to speed quickly,  thanks for all your help thus far.
0
 
knamcAuthor Commented:
Answered my own question.
0
 
jgvCommented:
>>"...has the values on the detail report Collapsed??"
I presume that you have a section on the detail report setup so that the user can expand/collapse the info (+ / - buttons). You need to set the property "InitialToggleState" to "Expanded" (it's set to collapsed by default).

Unfortuneatly, there is no way (that I have found) to return to the summary report other than using the back button on the browser. I worked someone else on this issue awhile back and it was never resolved.
0
 
jgvCommented:
I'm a little late on the button today :)
0

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now