SQLServerCentral / Reporting Services / Reporting Services / Forward Dependencies are not valid. / Latest Posts

RE: Forward Dependencies are not valid.

lysa.hastings — Tue, 27 Nov 2012 12:22:43 GMT

Thank you all so much for this post! I have been stuck on a problem like this for awhile now - changed the order and works like magic!!!

RE: Forward Dependencies are not valid.

raj.kaur — Wed, 05 Sep 2012 14:41:57 GMT

Thanks so much. I was pulling my hair out with this issue. After reading and applying your solution - it works !! Great, Thanks..

RE: Forward Dependencies are not valid.

DVSQL — Wed, 04 Apr 2012 15:06:42 GMT

Actually I found the problem. I was trying to create parameter drop down list from the same datasource as I was pulling the data from. Added another datasource and that took care of the issue.

RE: Forward Dependencies are not valid.

Andy Hyslop — Wed, 04 Apr 2012 05:37:53 GMT

If your getting this error it sounds like your parameter datasets are dependant - the only way I am aware to remove this is to edit the SQL for the dataset i.e.Parameter 1[code="sql"]SELECT *FROM SomeTable[/code]Parameter 2[code="sql"]SELECT *FROM SomeTableWHERESomeField IN (@Parameter1) /* Remove This*/[/code]However this may have been added for a reason - as this thread suggests I would re-order the parameters..Andy

RE: Forward Dependencies are not valid.

DVSQL — Tue, 03 Apr 2012 18:55:26 GMT

Is there a way to break or disable forward dependencies for SSRS. I've got a report that has parameters, which don't really have anything to do with each other. Whenever I try to add a drop down list for one of them, it tells me that they are all dependent on each other.

RE: Forward Dependencies are not valid.

suri.yalamanchili — Mon, 19 Mar 2012 13:17:38 GMT

Changing the order of the parameters resolves the issue.

RE: Forward Dependencies are not valid.

vandana.smiles — Wed, 22 Feb 2012 01:59:35 GMT

can you please explain in detailsas I have used a shared datasource which I have brought from my project.vandana

RE: Forward Dependencies are not valid.

Michelle Burke — Wed, 22 Feb 2012 01:43:47 GMT

Now you need to add the where clause to the query (or queries) that serve your report, not the query that populates the drop down.

RE: Forward Dependencies are not valid.

vandana.smiles — Wed, 22 Feb 2012 00:48:33 GMT

That's fine I have a dropdownlist and I can select multiple values but full report is being generated not specific to those values.

RE: Forward Dependencies are not valid.

Michelle Burke — Tue, 21 Feb 2012 21:09:30 GMT

You've created a circular reference. Your parameter is based on a query that needs the parameter value to run. Using justSelect districtname,districtcode from districtshould do the trick.

RE: Forward Dependencies are not valid.

vandana.smiles — Tue, 21 Feb 2012 20:53:02 GMT

look I want to generate report based on the selection of the drop down list(having district names)in the data set I have written the query Select districtname,districtcode from district WHERE districtname=@districtnamein the parameters properties I have selected the query option for the Available values and none for the default values and also checked the multiple choice option but I am not able to get selections from the dropdown list.vandana

RE: Forward Dependencies are not valid.

Jason Selburg — Tue, 21 Feb 2012 06:43:06 GMT

Whats are the details for that parameter? Default value, available values, etc...

RE: Forward Dependencies are not valid.

vandana.smiles — Mon, 20 Feb 2012 23:26:15 GMT

what if i have only one parameter.

RE: Forward Dependencies are not valid.

darth_vodka — Thu, 02 Feb 2012 03:04:52 GMT

i just had this in SSRS 2008and the parameter order change fixed itbut the parameters are different in 2008, on the report data...so i had to manually delete one and reinstate it at the end...which seems daft, but it worked(edit)http://msdn.microsoft.com/en-us/library/cc281392(v=sql.100).aspxno, was being thick, you can manually drag them, holding control and up/down works

RE: Forward Dependencies are not valid.

donne.medley — Wed, 24 Aug 2011 05:07:27 GMT

Thank you. That solved my problem. So easy.

RE: Forward Dependencies are not valid.

lcl74 — Fri, 17 Jun 2011 06:44:03 GMT

I am so glad I found your post. That solved my problem. Thank you so much!

RE: Forward Dependencies are not valid.

AlittleOverTheTop — Fri, 18 Mar 2011 07:02:05 GMT

I am having the same problem I think but I only have one parameters. The dataset is populated with the following sql:SELECT * FROM Course_Lesson WHERE Course_System_ID= @Course_System_IDThe @Course_System_ID parameters is pointing to =Parameters!course_system_ID.ValueParameters!course_system_ID.Value is a reportParameter with its available values property set to a dataset being populated by this sql:SELECT * FROM COURSEWhen I run the query my values don't show up. When I try to deploy the query I get an error:c:\documents and settings\petteysk\my documents\visual studio projects\report project6\report project6\On-Demand Attendance Report (by User) TestReport.rdl The report parameter ‘LessonTitle’ has a DefaultValue or a ValidValue that depends on the report parameter “course_system_ID”. Forward dependencies are not valid.Any Ideas?

RE: Forward Dependencies are not valid.

pamela.bertano — Thu, 16 Sep 2010 01:38:24 GMT

I was stuck with the very same issue and I thought I had to throw it all away when I read this topic, and it worked for me as well!!! THANK YOU!

RE: Forward Dependencies are not valid.

maxedout420 — Mon, 31 Aug 2009 11:47:07 GMT

Sorry... Forgot to update the forum..Thats exactly what I did and it worked!!Max

RE: Forward Dependencies are not valid.

U.T — Mon, 31 Aug 2009 11:35:30 GMT

[quote][b]maxedout420 (8/21/2009)[/b][hr]@startdate and @enddate are setup as date/time with defualt values of defaultstartdate and defaultenddate respectively....[/quote]use Non-Queried default values with following values for Start and End dates respectively.=DateAdd("d", -90, Today)=DateAdd("d", -60, Today)

RE: Forward Dependencies are not valid.

Michelle Burke — Sun, 23 Aug 2009 17:32:53 GMT

defaultstartdate and defaultenddate need to be calculated in a separate data set from your report data set. What you have defined in your query is that the parameters you want to filter the result set on are dependant on what the result set returns. See the circle there?

RE: Forward Dependencies are not valid.

maxedout420 — Fri, 21 Aug 2009 14:50:32 GMT

HelloI am having the exact same issuse and changing the order is not helping me...Summary of the problem:[code]SELECT a,b,c,, getdate() -90 AS defaultstartdate, getdate()-60 AS defaultenddateFROM x,y,zWHERE x.date BETWEEN @startdate AND @enddate[/code]@startdate and @enddate are setup as date/time with defualt values of defaultstartdate and defaultenddate respectively....I am getting the "Forward dependencies are not valid." errors...PLEASE HELP!!!ThanksMAX

RE: Forward Dependencies are not valid.

Cameron Mayfield — Wed, 25 Feb 2009 17:53:23 GMT

I was modifying a report that needed to behave just like yours when I ran into this error. I switched the order of the parameters and everything worked correctly. Thank you very much for this tip.

RE: Forward Dependencies are not valid.

jjafer — Sat, 31 Jan 2009 09:40:03 GMT

changing order from Report Parameters... did not work for me. any thoughts?

RE: Forward Dependencies are not valid.

giontech — Thu, 01 May 2008 14:58:43 GMT

Thanks

RE: Forward Dependencies are not valid.

Matthew Brown-402268 — Thu, 10 Apr 2008 07:05:56 GMT

Result!Thanks very much!

RE: Forward Dependencies are not valid.

DamienB — Thu, 13 Mar 2008 17:33:56 GMT

Good morning All,Changing the order of the parameters worked a treat for me. Very _very_ happy with that. I thought I might have to throw this whole report in the bin when I saw that error... T.TCheers - Damien

RE: Forward Dependencies are not valid.

srij — Thu, 07 Feb 2008 21:11:05 GMT

Thanks for ur reply.. it worked.. but another issue came..In my report i have 8 parameters.. and 3 are passed from code (from codebehind), and the rest 5 parameters will accept input from user.. but these 5 parameters depends on the role of the logged in user.. depending on the role 3- 4 parameter will get values from the user input.. the remaing 1-2 parameters will be passed with default(dummy) vaues. these are multi valued parameters...but while running the report i am geting error " ABC" Parameter missing a value ..Thanks in advance .........Pls help...

RE: Forward Dependencies are not valid.

Jason Selburg — Thu, 31 Jan 2008 07:58:49 GMT

If I understand you correctly, add a "dummy" parameter to the dataset that you're using for #2 that will come up if that particular parameter from #1 is selected.

RE: Forward Dependencies are not valid.

srij — Thu, 31 Jan 2008 07:54:30 GMT

hi,i also had the same issue..thanks for your reply.. now i could rectify it..but now another issue i have..i am using one dataset to populate a dropdown list which selecteditem is the input to second dataset..and i have 3rd dataset which is dependant on 2nd dataset selected parameter..if i select a particular item from the 1st dataset(dropdown list), i will not populate the 2nd dropdownlist(no o/p from 2nd dataset) .. but the 3rd data set does not require the 2nd dataset o/p to actually produce the output ie, that field can be null...but this feature iam not able to implement ..pls help ...Thanks in advans........

RE: Forward Dependencies are not valid.

sandygem2k — Wed, 28 Nov 2007 16:00:42 GMT

thanks Jason.. i was banging my head before i read your reply...

RE: Forward Dependencies are not valid.

dJeePe — Mon, 02 Apr 2007 15:39:00 GMT

Thanks Jason!That's just what I needed too!

RE: Forward Dependencies are not valid.

David Harder — Thu, 07 Sep 2006 06:42:00 GMT

That was exactly it. I didn't realize the order they appeared in the list was important. I do now. Thank you.

RE: Forward Dependencies are not valid.

Jason Selburg — Wed, 06 Sep 2006 18:04:00 GMT

It sounds to me like the order of the parameters are wrong. Does the SupID parameter appear above the EmpId parameter in the Visual Studio Parameter box?Just a stab, but I've had that issue before.

Forward Dependencies are not valid.

David Harder — Wed, 06 Sep 2006 07:27:00 GMT

I am working on reports from our HR system that allow a manager to only see their own direct reports data. This works fine by using the global UserID field parameter and joining to a table that contains the employee id of the supervisor as well as their network signon and then finding all the records in the personal data table where the supervisor id matches the value in this table.

However, some reports should be run on an individual and not all employees. My thought was to create a dataset where I look up all the employee ids and names that report to a supervisor as above. Then I would use this list to populate a dropdown list that the supervisor could use to choose an employee and then pass that parameter to the dataset that would populate the report. Seems logical to me but I get the following error

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

Build complete -- 1 errors, 0 warnings

If a parameter can not depend on another parameter I need some help to think outside this box I have created for myself as to how to accomplish this task.