I'm looking for some advise please. I need to write a Crystal Report that will identify what an employee's job code was on their hire date. For example, an employee is an RN III today, but when they were hired 5 years ago, they were hired as an RN I. In other words, a listing of all employees, showing their hire date and the original job they hired into. HR10 does show job code logging to history. I would appreciate any recommendations. I'm also willing to use Lawson Add-ins if that would work better. Thanks everyone.
I use Access to pull reports for this. I link the Employee table and PAEMPPOS tables and you can do the min and max function on the effective date to get the employees first position and current position.