i have two dropdowns one is customer and the other one is User.
1.if i select Customer, User dropdown should filter based on the Customer selection.
2.if i select User, Customer dropdown should filter based on the User selection. Its like reverse process. both the dropdown should filter based on these two dropdown selections.
i tried with the the following query.
select
Customer ,User
from
Customers
where
UserID in(@User)
or CustomerID in(@Customer)
but i am getting
Report parameter 'Customer' has a default value or a valid value that depends on the report parameter 'User' . Forward Dependencies are not Valid
any solution for this