Job History Report

SOLVED

Is there a way to pull a report that includes all job history for each employee?  I've tried creating a Secure Query with no luck.  Guessing it may be able to be done in Crystal?  Any advice is greatly appreciated!

Parents
  • 0
    SUGGESTED

    There is a report in the Crystal Library that can give you a good head start.  It is called Salary History.rpt and it should be available in your Data\Custom Reports\HR folder.  It has a detail line with information from the current data.  Then it has a Group Footer #2 line with information from your job history.  If you remove the fields on these two lines and replace them with the fields you need it will show you both the current job information and the job history information.  The field names will be similar except the current information will be something like p_jobcode and the history information will be named like j_jobcode.

    Good luck.

Reply
  • 0
    SUGGESTED

    There is a report in the Crystal Library that can give you a good head start.  It is called Salary History.rpt and it should be available in your Data\Custom Reports\HR folder.  It has a detail line with information from the current data.  Then it has a Group Footer #2 line with information from your job history.  If you remove the fields on these two lines and replace them with the fields you need it will show you both the current job information and the job history information.  The field names will be similar except the current information will be something like p_jobcode and the history information will be named like j_jobcode.

    Good luck.

Children
No Data