I want to prompt the user to select from a list of values provided by another query. The selected value should be the filter for the main report query. What I have done so far does not acknowledge the selected value. The report displays all rows in the query even though I have selected a parameter
Report Data
-ReportParameter1
Prompt=School
DataType=Text
Allow Multiple values
Available values-get from query
Dataset=school,
Value=school,
label=school
No Default
DataSet1
Filter [school]=Parameters!ReportParameter1.Value(0)
What else should I do so the report will use the selected value to filter the results?