Dundee Group Blog

San Francisco Area Crystal Reports Training for Sage Abra

We are also planning two days of Crystal Reports training in the San Francisco area in August.

San Francisco, CA August 4th. Course Fee: $690.
Abra Suite Basic Crystal Reports for HR
This one-day workshop is designed for beginning Crystal Reports users. This class will quickly give you the tools you need to create reports using the Report Wizard and give you a better understanding of the HR databases and dictionaries.

San Francisco, CA August 5th. Course Fee: $690.
Abra Suite Intermediate Crystal Reports for HR
This one-day workshop is designed for intermediate Crystal Reports users. This class will teach you how to create custom reports from both the Reports Wizard and a blank report. You will also learn how to link fields from different databases within Abra HR.

Use this link to register and for more information: http://bit.ly/a0LtKp

Posted by: Tim Ross

Los Angeles Area Crystal Reports Training for Sage Abra

We are planning two days of Crystal Reports training in the Los Angeles area next month.

Los Angeles, CA July 28th. Course Fee: $690.
Abra Suite Basic Crystal Reports for HR
This one-day workshop is designed for beginning Crystal Reports users. This class will quickly give you the tools you need to create reports using the Report Wizard and give you a better understanding of the HR databases and dictionaries.

Los Angeles, CA July 29th. Course Fee: $690.
Abra Suite Intermediate Crystal Reports for HR
This one-day workshop is designed for intermediate Crystal Reports users. This class will teach you how to create custom reports from both the Reports Wizard and a blank report. You will also learn how to link fields from different databases within Abra HR.

Use this link to register and for more information: http://bit.ly/a0LtKp

Posted by: Tim Ross

Duplicate Records Showing on Crystal Reports

Do you have a Crystal Report that sometimes gives duplicate records? This can often happen with older reports written in ODBC using the User DSN "Abra Suite Live Data". The duplicates can be caused by deleted records showing in the report. Sage Software recommends using Abra Data Access (ADA) to connect to the Abra Suite data rather than ODBC. If you run the System, Processes, Optimize Databases and your duplicate records no longer show in the report, then the problem is deleted records.

If you need to keep your report in ODBC and are getting duplicates, you need to check the configuration of the ODBC. On your computer go to Start, Control Panel, Administrative Tools, and Data Sources (ODBC). Select "Abra Suite Live Data" and click the "Configure..." button. Click the "Options" button to reveal the options. Checking the box to the left of "Deleted" will configure ODBC to ignore deleted records. Click OK to save and close out of ODBC. Refresh the report and the duplicates should be gone.

Posted by: Tim Ross