1.

Check that the Auto-Smart Linking option is disabled.  open Crystal Reports and select File | Options.  Click on the Database Tab.  Disable the Auto-Smart Linking option.

2.

Open the report from the \Accubld7\Reports directory and save in the new \Accubld8\Reports directory.

3.

Select Database from the main menu and choose Convert Database Driver.

4.

Check the Convert Database Driver on next Refresh box.

5.

Find and select pdsads.dll in the drop-down list and click OK.

6.

You will be prompted for an Advantage Alias to use in this report. Either select an existing alias from the list provided, or click New to create a new alias.  If the Advantage Alias dialog does not appear immediately press the F5 key to force a refresh. Note: AccuBuild highly recommends that you select the free table alias that should have been created when configuring the Crystal Reports program to interface with the Advantage Database Tables as this set of free tables should include all tables from the Company, User and System directories.

7.

Check the Converting Report From BDE Driver box and click OK.  An informational dialog will be shown reminding you to change each link in your report to the 'outer join' type.  You will receive two Advantage Client Engine Errors and one Crystal Reports Database Error for each database file that is in the report.  Click OK on each error.

8.

You will then need to change the file extension on each database table.  Select Database from the main menu and choose Select Location.  Click on each database table and change the file extension from .db to .adt.  Click Done. Crystal will report that the base tables have changed and ask you if you want to fix up the report. Click Yes for each table.

9.

All links in the report must be converted to the 'outer join' link type in order to emulate the BDE flat file driver linking behavior. The BDE flat file driver (pdbbde.dll) includes all rows in a parent table in the result set, even if a matching key value does not exist in the child table(s). This is equivalent to an SQL left outer join. By default the Advantage Crystal Driver uses standard SQL joins (inner joins) and will not return rows unless they have matching keys in the child     table(s). For this reason, all links in a report previously built using the pdbbde driver must be converted to left outer join links in order to return the same results the original report returned.  Follow these steps to change each link type:

9a.

Choose Database from the main menu and select Visual Linking Expert.

9b.

For each link in the report do the following:

9b1.

Select the link by clicking on the link line.

9b2.

Click the Options Button.

9b3.

Change the SQL Join Type from Equal to Left Outer.

9c.

Close the Visual Linking Expert.

10.

Save the report using the original file name. Note:  The custom reports feature will now allow the custom report file to be saved in ANY folder instead of just the company folder