XI parameters

[Lhuffst]

I have a report in XI that has 3 parameters: Start Date, End Date and User Name. The dates work fine but I have a question about the User Name.

I created a string parameter of dynamic type thinking that I would map it to the field. This works but it only shows 3 out of 7 names.

I am using an oracle database and when I run the query directly in SQL, I get all 7 names. Also, I need to add the word all to the top of the list so they can choose all, one or more people.

The parameters work a little different than 9.0 so I'm not sure what to look at and any suggestions would be helpful.
Thanks
lhuffst

 

[Lhuffst]

Sorry to have troubled you. After rereading many posts, I deleted the parameter that I had and re-entered the code that I found on this terrific site and now it works.
Thanks to everyone and LB you rock!