Unanswered: Need parameter help for distinct output
Hi, perhaps you can help me.
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