Summary
Creating a custom crystal report for Sage HRMS
Description
Cause
Resolution
Steps to create Crystal HRMS Payroll SQL Report:
- In Crystal select Blank Report in start a New Report
- Select Create New Connection
- Select OLE DB (ADO)
- Change Provider to Microsoft OLE DB Provider for SQL Server
- Fill in the Connection information and include the "Company Database"
Steps to create Crystal Sage HRMS SQL Report:
- In Crystal select Blank Report in start a New Report
- Select Create New Connection
- Select OLE DB (ADO)
- Select Sage Abra HRMS Data Access
- Select the desired tables