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!
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…
Browse to the server where the Sage HRMS application is installed. The default install directory on the server is c:\ProgramData\Sage\SageHRMSServer\Data\CustomReports. You may have a mapped drive and the…
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.
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.
*Community Hub is the new name for Sage City