SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Forward Dependencies are not valid.


Forward Dependencies are not valid.

Author
Message
LostAccount
LostAccount
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4461 Visits: 1424

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.


Jason Selburg
Jason Selburg
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6946 Visits: 4115
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.

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg
LostAccount
LostAccount
SSCarpal Tunnel
SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)SSCarpal Tunnel (4.5K reputation)

Group: General Forum Members
Points: 4461 Visits: 1424
That was exactly it. I didn't realize the order they appeared in the list was important. I do now. Thank you.
dJeePe
dJeePe
SSC Veteran
SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)SSC Veteran (210 reputation)

Group: General Forum Members
Points: 210 Visits: 2385
Thanks Jason!
That's just what I needed too!
sandygem2k
sandygem2k
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 Visits: 60
thanks Jason.. i was banging my head before i read your reply...
srij
srij
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 10
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........
Jason Selburg
Jason Selburg
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6946 Visits: 4115
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.

______________________________________________________________________

Personal Motto: Why push the envelope when you can just open it?

If you follow the direction given HERE you'll likely increase the number and quality of responses you get to your question.

Jason L. Selburg
srij
srij
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 Visits: 10
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...
DamienB
DamienB
SSC-Enthusiastic
SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)SSC-Enthusiastic (160 reputation)

Group: General Forum Members
Points: 160 Visits: 142
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.T

Cheers - Damien
Matthew Brown-402268
Matthew Brown-402268
SSC Veteran
SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)SSC Veteran (279 reputation)

Group: General Forum Members
Points: 279 Visits: 68
Result!

Thanks very much!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search