Link to home
Start Free TrialLog in
Avatar of Sue Taylor
Sue TaylorFlag for United States of America

asked on

Crystal Reports Formula

I can't figure out how to create the formula to show the instructor's name on my report.  I have a field that lists the instructors name as his employee number {view_PT_Training_Instructor.Instructor}  then on a different table I want to pull the first and last name.

My formual Instructor Name is....  {view_PT_Training_Instructor.Instructor} & "-" & {view_PT_Employee.First_Name} & " " & {view_PT_Employee.Last_Name}

The name associated with employee # 1276 is SUE TAYLOR and I would like my report to display 1276-Sue Taylor but instead it is displaying 1276-The first person listed on the report in this case James Goldstein.

I can't figure out what I'm doing wrong.
--mail-staylor--Custom-Reports-Train.rpt
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Move the formula from the Report Header to the Detail section.
SOLUTION
Avatar of Ido Millet
Ido Millet
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial