SSRS - MultiValue Param - distinct?

I have a query that has a field called Region in it.  The region is across multiple records.  I tried using a multi-value but it shows the same value over and over. So I created a second dataset of distnct values.  Do I need to somehow tie that to the main query to filter the results and how do I do that?  

Who is Participating?
zephyr_hex (Megan)Connect With a Mentor DeveloperCommented:
i'm not entirely clear on what you're trying to achieve, so i have two responses.

if you are just trying to keep from having region show multiple times, have you considered adding a Group to your table?  when you group by region, then you can display the region in the group row, and the details that differ for each record in the details row.

if you are indeed trying to filter by region, i'm assuming you have a parameter for region.  you'll want that parameter to be based on a query to your dataset that has distinct region values.  then filter your table by that parameter.
sbornstein2Author Commented:
had to use the param and multi filter
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.