The error we will be discussing in this article is: ‘[rsInvalidReportParameterDependency] The report parameter ‘X’ has a DefaultValue or a ValidValue that depends on the report parameter “Y”. Forward dependencies are not valid.‘
Or in this example:
'[rsInvalidReportParameterDependency] The report parameter 'Employee' has a DefaultValue or a ValidValue that depends on the report parameter "EmployeeCompany". Forward dependencies are not valid.'
As you can see in the screenshot below, I have two parameters ‘EmployeeCompany’ and ‘Employee’. The ‘Employee’ drop-down list is populated depending on the selection of ‘EmployeeCompany’ for this we use a dataset where the ‘EmployeeCompany’ parameter is passed. But as you can see, the dropdown list of ‘Employee’ is before ‘EmployeeCompany’.
- ‘Employee’ depends on ‘Employee Company’
- ‘Contract’ depends on ‘Company’
If we swap their locations, the error goes away and the report will build just fine. As you can see in the screenshot above, the order of the ‘Contract’ and ‘Company’ parameters was already correct, which was why we were not receiving any errors for those two.
