I have a value prompt dropdown list on a report when there are 25 user ids. But my dropdown list is displaying over 1000 user ids. I'd like the values in the prompt dropdown to reflect the same number of users on the report.
I tried pointing the prompt dropdown list query to the query that is driving the report, but that didn't work.
you probably need to just filter the prompt query. the prompt query should be separate from the main query.