I have a report with two report parameters (Cities and Streets).
My SQL query looks like:
City ID | City Name | Street ID | Street Name
1 | Paris | 1 | Street P1
1 | Paris | 2 | Street P2
2 | London | 3 | Street L1
2 | London | 4 | Street L2
3 | Rome | 5 | Street R1
Now I want to have a two-way dependency between these two dropdowns.
1. If I choose a city from the cities dropdown, I want to see only the streets of the choosen city in my streets dropdown.
2. If I choose a street from the streets dropdown, I want that the city dropdown is automatically filled with the city of the choosen street.
How can I do this?
It was easy to create a filter for an one-way dependency (if I choose a city, I only see the streets of the city) but I do not get it out that both work.
Thank you for any help