I use these formulas to create first and last name fields in crystal reports.  The employee names must all be in the format of LAST; FIRST (with the space after the semi-colon). Some of our older employees did not have the space in their name.

FIRST NAME:

If Instr({MASTER_PRM_EMPLOYEE.Employee_Name},"; ") = 0 Then
right({MASTER_PRM_EMPLOYEE.Employee_Name},len({MASTER_PRM_EMPLOYEE.Employee_Name})-instrrev({MASTER_PRM_EMPLOYEE.Employee_Name},";"))
Else
Mid({MASTER_PRM_EMPLOYEE.Employee_Name}, InStr({MASTER_PRM_EMPLOYEE.Employee_Name},";")+2)

LAST NAME:

Left({MASTER_PRM_EMPLOYEE.Employee_Name},InStr({MASTER_PRM_EMPLOYEE.Employee_Name},";")-1)

And if you only want Active Employees to be listed, you can use this formula in the Record Selection:

isnull({MASTER_PRM_EMPLOYEE.Termination_Date})
or
{MASTER_PRM_EMPLOYEE.Rehire_Date} > {MASTER_PRM_EMPLOYEE.Termination_Date}