Related topics

Creating a custom report

Modifying a custom report

Custom reporting with SAP Crystal Reports

Abra HRMS Data Access

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 and prompts you to log on.

After you are logged on, Abra HRMS Data Access checks your security settings. This enforces employer security, product group filters, and ad hoc reporting security. If you do 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 zeros 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. We recommend that 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

  1. Select Connected Services > Sage HRMS Tools > Crystal Reports to launch SAP Crystal Reports.
  2. In the Welcome to Crystal Reports window, select Blank Report and click OK.
  3. In the Data Explorer window, click Options.
  4. In the Options window for List Tables and Fields by section, select Both and click OK.

  5. In the Data Explorer window:

    1. Click the plus sign to expand More Data Sources.
    2. Click the plus sign to expand OLE DB.
    3. Click once to highlight Make New Connection.
    4. Click Add.
  6. The Data Link Properties window, click once to highlight Abra HRMS Data Access (OLE DB Provider) and click OK.

  7. In the Data Explorer window:

    1. Under OLE DB, click once to highlight Abra HRMS Data Access.
    2. Click Add to Favorites.
    3. Click the plus sign to expand Favorites.
    4. Click the plus sign to expand Abra HRMS Data Access.
    5. Scroll through the list until you find the tables you want to include in the report and click once to highlight each of the tables.

    6. Click Add.

      A check mark is added to the tables you selected for the report.

    7. When you finish selecting the tables for the report, click Close.

The report opens in Design mode with the Field Explorer window visible.

If you created reports using Sage HRMS Live Data or Sage HRMS Sample Data, use the Convert Database Driver menu item to change the database driver to use Abra HRMS Data Access.

  1. Select Connected Services > Sage HRMS Tools > Crystal Reports to launch SAP Crystal Reports.
  2. In the Welcome to Crystal Reports window, select Open an Existing Report and then More Files.
  3. Click OK.
  4. Navigate to the appropriate folder and open the .RPT file (such as Employee List DEU.rpt) to open the report in Design mode.
  5. In the SAP Crystal Reports main menu, select Database > Convert Database Driver.

  6. In the Convert Database Driver window:

    1. Select the Convert Database Driver on next Refresh check box.
    2. In the To drop-down list, select pdsodbc.dll (OLEDB).
    3. Click OK.
  7. In the Data Link Properties window, click once to highlight Abra HRMS Data Access (OLE DB Provider), and then click OK.

  8. In the Verify Database window for each table included in the report, click OK.

    The report opens in Design mode.

  9. In the SAP Crystal Reports main menu, select File > Save As and save the report.