It is no secret that a lot of organizations are either considering to or already migrating from SAP Crystal Reports to Microsoft SSRS Reports. The reasons for this change vary from the feeling that Crystal Reports is nearing EOL, pricing or change in technology stack.
What is also not a secret is that most organizations have had Crystal Reports in use for many years and therefore they have in that time created hundreds (if not thousands) of very useful and business-critical reports. The question then arises; how do you convert all your Crystal Reports to SSRS Reports so that you do not have to do it all manually?
Lets get the bad news out of the way. There is no 100% single-push button solution to converting Crystal Reports to SSRS Reports. There two reporting platforms are too different in design and architecture for such a solution to exist.
In this article, we are going to look at the options that exist in reducing the amount of time and effort required to transition from Crystal Reports to SSRS Reports.
Crystal Migration Services Corp
http://www.crystalmigration.com
Crystal Migration Services provides leading-edge conversion services since 2011. They clain to convert any version and any complicated Crystal Reports to SSRS 2005, 2008, 2012 and 2016. Their conversion accuracy and capability set them apart in the industry. Their automatic solution has clone like accuracy, and can converts lots of features such as crosstab that their competitors have to do by hand. Any other automatic conversion solutions can only cover at most 75% of what they can do.
Visionet
https://www.visionetsystems.com/crystal-ssrs
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
Manually Converting a Crystal Report to SSRS
http://caidynamics.com/super-easy-migration-of-crystal-reports-to-microsoft-ssrs-reports/
You can manually convert a Crystal Report to SSRS by copying the SQL Query from Crystal Reports and using it as a basis for your SSRS Report. This method is obviously the most time consuming and is only suitable if you only have a handful of reports to convert. More information can be found at the above link.