Combine two fields into one parameter

[KZOG]

I am on version 8.5.

I have two fields. Employee Last Name field and an Employee First Name field.

I would like to create one parameter that will allow the user to select the entire name field (last name + first name) instead of having to select the first name parameter and then having to select the last name parameter. Does that make sense?

 

[lbass]

Do you have an employee ID number? You could create a separate report with employee ID and a formula that concatenates the first and last names, then export this to a text file and remove the quotation marks and then import this for the default values of the parameter. You could then set the defaults to display only the description (full name), but set the parameter = to the employee ID number in the record selection statement. This also avoids the problem of employees with the same name.

-LB