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.