I am having trouble trying to use dependent parameters. I have the Reporting 2010 Q2. I have 8 images for the figure #'s described below.
1. I have SQLDatasource, using a stored proc, called Providers that gets a list of Providers. This stored proc returns Name and Id fields. Figure 1.
2. I have a ReportParameter called Provider that uses the Providers Data Source for its DataSource. Name is the DisplayMember and Id is the ValueMember. That works and displays correctly in Preview Mode in the designer and on the Report Viewer.
3. I have a second SQLDatasource, using a stored proc, called ProviderClasses that gets a list of Classes for the selected Provider. The stored proc returns Name and Id fields. This stored proc takes a parameter. Figure 3. The parameter is set to the Parameters.Provider.Value.Figure 4.
4. I have a ReportParameter called ProviderClass that uses the Classes Data Source for its DataSource. ClassName is the DisplayMember and Id is the ValueMember. Figure 5. This displays an error message and shows no values when I change the Providers dropdown. Figure 6.
If I open SQL Profiler and I select a provider, it does call the stored procedure with the Id of the selected Provider to populate the classes. When I run this exec command copied out of Profiler in a query window it returns the classes as expected. However, they don't populate the Class dropdown list on the Report Viewer. Figures 7 & 8.
I followed the examples even though they were using SQL text and not stored procedures.
What am I doing wrong?