Abra HRMS Data Access provides ease of use and security for custom reporting using SAP Crystal Reports with Sage HRMS.
You must be logged onto Sage HRMS in order to work with any custom reports that specify Abra HRMS Data Access as the data source. When you select a custom report, Abra HRMS Data Access automatically verifies that you are logged onto Sage HRMS. If you are not logged on, the Sage HRMS logon page opens prompting you to log on.
After you are logged on, Abra HRMS Data Access checks each user's security settings which enables you to enforce employer security, product group filters, and ad hoc reporting security. If a user does not have access to a field:
- Character fields display Xs for the full size of field
- Numeric fields display 1 in the left most position and are zero filled for the remaining positions of the field
- Date fields display the date 01/01/1900
The first time you create your own custom report, you must specify Abra HRMS Data Access as the data source. You need to specify the data location only once. After specified, we recommend you add Abra HRMS Data Access to the Favorites list to enable you to quickly and easily select tables for custom reporting.
If you are using the custom reports shipped with Sage HRMS, the data source automatically defaults to Abra HRMS Data Access.
Actions for Abra HRMS Data Access
Specify Abra HRMS Data Access
- From the
- Select Blank Report and click . The Data Explorer dialog box opens.
- Click Options. The Options dialog box opens.
- In the List Tables and Fields by section, select Both.
- Click . The Data Explorer dialog box opens.
- Click the plus sign to expand More Data Sources.
- Click the plus sign to expand OLE DB.
- Click once to highlight Make New Connection.
- Click . The Data Link Properties dialog box opens.
- Click once to highlight Abra HRMS Data Access (OLE DB Provider).
- Click . The Data Explorer dialog box opens.
- Under OLE DB, click once to highlight Abra HRMS Data Access.
- Click Add to Favorites.
- From the Data Explorer dialog box, click the plus sign to expand Favorites.
- Click the plus sign to expand Abra HRMS Data Access.
- Scroll through the list until you find the tables you want to include in the report and click once to highlight the tables.
- Click . A check mark is added to the tables you select for the report.
- Click when you've finished selecting the tables you need for the report.
- The report opens in Design mode with the Field Explorer dialog box visible.
Convert Database Driver to use Abra HRMS Data Access
If you have created reports using Sage HRMS Live Data or Sage HRMS Sample Data, use the Convert Database Driver command to change the database driver to use Abra HRMS Data Access.
- From the
- Select Open an Existing Report and More Files….;
- Click OK.
- Navigate to the appropriate folder and open the .RPT file, for example, Employee List DEU.rpt. The report opens in Design mode.
- From the SAP Crystal Reports main menu, select Database > Convert Database Driver. The Convert Database Driver dialog box opens.
- Check the Convert Database Driver on next Refresh check box. The To drop-down list is enabled. From the To drop-down list, select pdsodbc.dll (OLEDB).
- Click . The Data Link Properties dialog box opens.
- Click once to highlight Abra HRMS Data Access (OLE DB Provider).
- Click . The Verify Database dialog box opens for each table included in the report.
- Click . The report opens in Design mode.
- From the SAP Crystal Reports main menu, select File > Save As and save the report.