Crystal Reports to SSRS Conversion

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

crystal-ssrs-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

crystal-ssrs-conversion-strategy-2

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)

crystal-report-output-1

Converted Report(SSRS)

crystal-report-output-2

Converted Report (After Enhancements)

crystal-report-output-3

 


Testimonials

Additional Resources

2

Webinars

Challenges in meeting the GSE mandate for uniform closing dataset (UCD) delivery
Date: September 20th, 2016 02:00 PM EST

Learn More & Register