In my report I have to match user ID's with 179 Badge Reader ID's and the locations that go along with it. I need to create a parameter that when prompted for user input for any locations, it selects the distinct user name, ID and publishes them in the report. I have the report format completed already.

 

Here are several issues I am facing.

 

1. A user ID can be used for more than one reader

2. When I use the parameter for any location, I receive 8061 records, and they should vary, as not everyone has access to every single reader

 

Any suggestions?