How to Convert Custom Crystal Reports

CYMA uses Crystal Reports Version 10 as its runtime report engine. Forms created in Crystal Reports Version 8.x will not run

How to Convert Custom Reports using Crystal 10

  1. Locate the custom report you wish to convert.
  2. Open the custom report into the Crystal Report Version 10 program.
  3. Select Database from the main menu.
  4. Select Set Datasource Location from the drop down menu.
  5. In the "Replace with" window, expand the Create New Connection folder.
  6. Then expand the Btrieve folder underneath it.
  7. This will bring up an 'Open' window allowing you to select a data dictionary file.
  8. Browse out to the MAIN Cyma4 program directory and choose the FILE.DDF file. You must select the FILE.DDF.
  9. Now you will have a list of all the possible database files in the "Replace With" window.
  10. Select the first FILE.DDF used in your report in the "Current Data Source" window and select it's matching FILE.DDF in the "Replace with" window.
  11. With both files selected click on the UPDATE button.
  12. Repeat steps 10 and 11 for each FILE.DDF listed in the "Current Data Source" window (sub menus).

    NOTE: If you receive the message:

    "Some tables could not be replaced, as no match was found in the new data source. Please specify the table required for any unmodified tables"

    Highlight the old CYMA file name (Sm_Bank4, Pr_Em3, etc.) and the new file name (refer to 'File Structure Changes' for your specific version) and choose Update. This should also be done inside of each sub report. Next, perform steps 14-16 for each updated new file name.
  13. After all FILE.DDF and/or CYMA file names have been updated to a matching file, press the CLOSE button.
  14. From the main menu choose Database again.
  15. From the Database menu choose Database Expert.
  16. If any of the files used on the report have a new filename (see step 12) you will need to set alias names. Click on the filename that has changed and press the F2 key. Type in the new filename. Repeat this step for each file that has changed.  NOTE: If your report contains sub-reports steps 14-16  (renaming changed files) should be done inside of each sub report.
  17. Click on the LINKS tab to bring up the Visual Linking Expert screen.
  18. Click on the OK button.
  19. From the Database menu choose Verify Database. You have succeeded if the response is: "The database is up to date." If not, please go back to step 4.
  20. Save the custom report in the appropriate location (Forms are saved in the forms directory, reports are saved in the main CYMAIV directory).
  21. Congratulations! You are finished.

NOTE: Any Crystal 8.0 reports that linked from one file to many files and used the 'Look up all of one, then the other' linking option will not have similar linking options in Crystal 10 and will probably need to be rewritten. This applies mainly to reports that pulled in Current and Historical transactions onto a single report.