Crystal to SSRS

Crystal to SSRS

Microsoft – Reporting Service Architecture

Reporting Service Architecture

Visionet Conversion Methodology

Visionet employs its hardened tested platform Re-engineering methodology to convert Crystal reports to the SQL server reporting services.

Visionet has developed a number of tools and utilities for platform migration tasks that are utilized to automate labor intensive tasks to ensure integrity of the migrated reports and to streamline their testing.

Conversion Strategy

  • Automated Conversion using proprietary tools
  • SSRS Data source configuration
  • Stored Procedure/DB Analysis
  • Performance Reviews
  • Enhancements using Visual Studio IDE
  • Integration/Unit Testing
  • Regression/Functional Testing
  • Reports Deployment & UAT
  • Production Rollout

Visionet Conversion Strategy

Visionet Automated Conversion Strategy

Assessment/Analysis

The Visionet team will Identify the complexity level of each report according to the following criteria:

  • Simple Reports
    • Standard Reports without any grouping/calculation
  • Medium Reports
    • Parameterized reports with Groups
    • Standard Graphs/Filters
    • Formulas/Calculations
  • Complex
    • Cross tab reports
    • Sub Reports
    • Complex formulas

Assessment/Analysis

Automated Conversion using tools

  • Automated Approach to Convert .rpt format into RDL
  • Maintains mapping information in .XSLT
  • Mapping Information is configurable
  • Engine will generate the SSRS XML document

Product Report (Crystal Report Output)

Product Report (Crystal Report Output)

Converted Report (SSRS)

Converted Report (SSRS)

Converted Report (After Enhancements)

Converted Report (After Enhancements)

For more information, please visit Platform Modernization.