troubleshooting Question

visual studio report

Avatar of dwiseman3
dwiseman3Flag for Afghanistan asked on
Microsoft DevelopmentSSRS
1 Comment1 Solution303 ViewsLast Modified:
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?
ASKER CERTIFIED SOLUTION
Tony303

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros