• Crystal Report Formulas

    Employee Emp Name Per Begin Date Period End Date Fringe ID Amount Deduction ID Amount 1001 Jackson, One 1/4/2021 1/10/2021 MEDEMP $ 220.00 MED01 $ 95.00 1003 Jackson, Three 1/4/2021 1/10/2021 MEDEMP…
  • Database Schema for Sage 300 CRE?

    FormerMember
    FormerMember
    Does anyone have any comprehensive form of databse schema or detailed data dictionary for Sage 300 CRE when trying to access using ODBC? I have been trying to find one for some time that details the table locations of data fields and have found Sage documentation…
  • Connecting Crystal Reports 2016 to Sage 100 Contractor v20.5

    FormerMember
    FormerMember
    I'm trying to connect Crystal Reports 2012 to Sage 100 Contractor v20.5 via an ODBC connection. I have created the ODBC connection successfully by allowing access from other applications (DAT->Advanced Settings...->Advanced SQL Server Settings->Edit Approval…