<div>
It works when establishing a different data set for each parameter. &nbsp;The question now is, how can I filter the primary data set based upon these parameters?
</div>


It works when establishing a different data set for each parameter.  The question now is, how can I filter the primary data set based upon these parameters?

<div>
<div class="content wysiwyg-content">
I have a parameter in my SSRS report that has the 'Available values' set within the parameter properties. &nbsp; Further, the radio box button 'Get values from a query' has been selected so that a list box is then populated by values from a field within a particular table. &nbsp; The data in that field is not unique resulting in the list box showing it numerous times, which is redundant (see attached screen shot).<br />
<br />
How do I limit a list box parameter in SSRS to show only distinct text values?<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/01_w01/1137207/Capture.PNG" target="_blank" class="file-inline" title="Screen shot of List box with dupes (26 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Capture.PNG</a>
</div>
</div>


Capture.PNG

I have a parameter in my SSRS report that has the 'Available values' set within the parameter properties.   Further, the radio box button 'Get values from a query' has been selected so that a list box is then populated by values from a field within a particular table.   The data in that field is not unique resulting in the list box showing it numerous times, which is redundant (see attached screen shot).

How do I limit a list box parameter in SSRS to show only distinct text values?

SSRS List box paramaters showing duplicate choices

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.