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
