We are using Reporting Services to design and deliver reports. We have a report that we need to filter via Client, however the filter populates with multiple instances of the same client.

We are pulling in the values for the filter from a dataset.

We have users that are associated with clients. So multiple users have the same client. In this filter drop-down when it populates from the dataset it is populating the same client multiple times based upon how many users are associated with that client. All we need is each client a single time. We can do this by creating another dataset, but we would like to do it with the current dataset instead of making a trip back to the server. Your help is appreciated. Thanks!