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