Create crystal report for Sage HRMS

How to create a custom crystal report for Sage HRMS

Create Crystal HRMS Payroll SQL Report:

1. In Crystal select Blank Report in start a New Report.
2. Select Create New Connection.
3. Select OLE DB (ADO).
4. Change Provider to Microsoft OLE DB Provider for SQL Server.
5. Fill in the Connection information and include the "Company Database".

Create Crystal Sage HRMS SQL Report:

1. In Crystal select Blank Report in start a New Report.
2. Select Create New Connection.
3. Select OLE DB (ADO).
4. Select Sage Abra HRMS Data Access.
5. Select the desired tables.