Crystal Reports Migration

Tony Coffman -

VDM offers some assistance for users migrating from Crystal Reports to VDM.

Prerequisites

To migrate a Crystal Report you must:

  • Install both the 32-bit and 64-bit SAP Crystal Reports runtime engine for .Net framework MSI.  Both downloads are available here .


What Migrates?

VDM's migration process brings over the following Crystal Report objects to VDM:

  • Report Tables and Fields
  • Record Selection (Filter Statement)
  • Linking and Joins
  • Parameters
  • Report Design and Layout
  • Grouping
  • Report Sections
  • Formulas/Calculated Fields (in Crystal Syntax)
    • Formulas/Calculated fields come over into the Finished Report in Crystal Syntax and will need to be manually translated to VDM syntax.

 

What Does not Migrate?

VDM does not migrate the following Crystal Report objects, if they exist, and will need to be manually added after the migration:

  • Sub Reports
  • Fields formats for Currency, Numeric and Dates
  • Images
  • Charts

  

Getting Started

  1. Launch VDM and connect to the database connection profile being used by Crystal Reports

  2. Click Open from the Ribbon Bar and browse to the Crystal Report.  Click the Open button to select.mceclip0.png

  3. By default VDM will bring in the Tables, Fields, Filters, Parameters and Linking.  You will be prompted to bring the graphical elements of the Crystal Report into Finished Reports.  Choose Yes or No.mceclip1.png
  4. Review the Report Fields under the Tables and Field's control and make any needed adjustments or corrections.mceclip2.png

  5. Review the Filter Statement under FSGS and make any needed adjustments to conform with VDM/SQL syntax.mceclip3.png

  6. Review Linking and if any adjustments are needed it is recommended you click "Clear Links" and manually link the tables.mceclip4.png

  7. Review Parameters and make any needed adjustments or corrections.mceclip5.png

  8. Click Run View from the Ribbon Bar and review the query results in the Details Grid.mceclip6.png

  9. Next, click the Finished Reports Designer from the Ribbon bar.  Review the Finished Report and make any needed adjustments to Sub Reports, Images, Charts, Field Formats and Formulas/Calculated Fields.mceclip8.png

  10. Click Preview to review the migrated report, and then the Save button to save the report in VDM format.

 

Summary

Our goal with the Crystal Reports Migration process is to offer users and path from Crystal Reports to VDM for simple to moderate reports.  Depending on the complexity of your Crystal Report you will see varying degrees of success with your migration.  BridgeWorks does not provide support or assistance for Crystal Reports. 

Have more questions? Submit a request

Comments