Get the Display value of a variable drop-down to display on report

I have a report where the drop-down list is presented to the User at runtime.
This drop-down list displays the User First and Last Name as the option of
the drop-down. But, the value of their selection is set to the EmployeeID.
How do I get the select Full Name to appear on the report for the selected
name from the variable drop-down list?
thanks,
SeanHi Sean.
You need to return the full name in your result set or pass it in as another
parameter.
--
Regards,
Tim Ellison, MCP
Ironworks Consulting, LLC
(m) 804.405.4874
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:00CC804C-31A7-4740-A670-C605BF162A05@.microsoft.com...
> I have a report where the drop-down list is presented to the User at
runtime.
> This drop-down list displays the User First and Last Name as the option of
> the drop-down. But, the value of their selection is set to the
EmployeeID.
> How do I get the select Full Name to appear on the report for the selected
> name from the variable drop-down list?
> thanks,
> Sean
>