I am creating a report where the user has 2 parameters to enter a range for Sales Rep. 1002 to 4500.
I print the user selection in the header as
Sales Rep 1002 - 4500.
A request has been made to instead of showing the sales rep number to instead display the name. So they would want to see:
Sales Rep: John Smith - Mike Johnston, where 1002 = John Smith and 4500 = Mike Johnson when selecting 1002 - 4500.
How can I display the names in the header? The name does not exist in the one table I am using so I don't know how to use the parameter to link to the sales rep table to get the name.
Is this possible?
Thanks