Sometimes it is necessary to remove tables from a report if they have been replaced by other tables and no longer needed. The following order is absolutely crucial to avoid breaking the report and causing numerous errors.

Note: Always remove the table(s) from the Crystal Report first before removing it from the database export.

Crystal XI
  1. Open the report in the Crystal application
  2. Delete any fields on the report or in formulas that are contained in the table(s) to be deleted
  3. Select Database > Database Expert from the menu
  4. Select the desired table to remove from the Selected Tables list
  5. Click on the < arrow button
  6. Repeat steps 3 and 4 for all other tables that need to be removed
  7. Click OK, then OK again
Crystal 8.5
  1. Open the report in the Crystal application
  2. Delete any fields on the report or in formulas that are contained in the table(s) to be deleted
  3. Click on Database > Remove from Report from the menu
  4. Select the desired table to remove from the Databases list
  5. Click the Remove button
  6. Repeat steps 3 and 4 for all other tables that need to be removed
  7. Click Done