In Reporting Services how to filter drop down parameter list in based on other selected parameter?
- by Lee Englestone
Question
In a Reporting Services Report, How do I filter a second drop down list of cars to only show cars whose ManufacturerId is equal the selected Manufacturer (from the first drop down list)?
Report Datasets
I have 2 datasets.
Dataset 1. A list of Manufacturers.
From a stored procedure Report_Manufacturers_P
Dataset 2. A list of Cars, including a column called Manufacturers id.
From a stored procedure Report_Cars_P
Report Parameters
On the Report I have 2 Parameters.
Parameter 1. ManufacturerId. Set from A drop down list of Manufacturers (DataSet 1).
Parameter 2. CarId. Set from A drop down list of Cars (DataSet 2).
I've tried..
Creating another sproc called Report_Manufacturer_Cars_P that takes the ManufacturerId as an integer and returns a list of cars made by that manufacturer.
Any Ideas. As selecting a Manufacturer doesn't seem to want to kick off anything that filters the Car list?
Thanks in advance,
-- Lee
