Solved

Crystal Report 10 to SQL Server SSRS 2008R2

Posted on 2011-09-24
8
1,011 Views
Last Modified: 2012-05-12
Is there a way to migrate/convert crystal reports 10 (designed in Visual Studio 2010 .net) to SSRS? If so how can you and will it maintain formatting?
0
Comment
Question by:SPLady
  • 3
  • 3
  • 2
8 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 36594037
Here is a tool that claims to be able to do it

http://www.ktlsolutions.com/Products/CrystalConverter.aspx

I haven't used it or heard any feedback on it.

mlmcc

0
 
LVL 1

Author Comment

by:SPLady
ID: 36594046
Thank you! Do you know what method is used for the conversion?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 36594076
No.  It is a program they wrote.  I believe you provide a file when prompted nd it opens it and converts it.

mlmcc
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 100

Accepted Solution

by:
mlmcc earned 167 total points
ID: 36594082
A short review from Ken Hamady
Convert Crystal Reports to SSRS XML files

--------------------------------------------------------------------------------
Those of you who have considered switching from Crystal Reports to SQL Server Reporting Services may have been cowed by the thought of recreating all of your existing Crystal Reports in SSRS XML format. If so, you should check out a new tool published by KTL Solutions in Frederick, MD. Crystal Converter is designed to convert RPT files into SSRS compatible XML files. Not all features of the RPT will be converted but I was surprised at how many CR objects are supported. The list includes formulas, SQL expressions, running totals, charts, sections, groups and summary fields. It works with Crystal Reports files from v9 through v11.

Review taken from Ken Hamady's newsletter
http://www.kenhamady.com/news0703.shtml

mlmcc
0
 
LVL 27

Assisted Solution

by:planocz
planocz earned 333 total points
ID: 36596367
One way is you just open the CR report and look at the layout. Then create the SSRS report to look the same as the CR Report. Last Summer I work with a Company on moving CR to SSRS. I myself physically converted over 1200 reports in about 6 mos.. If you have questions then converting just ask and we will try and help.
0
 
LVL 1

Author Comment

by:SPLady
ID: 36596388
Thanks Planoco,

So there is no easy way to do this... Did you have to  manually recreate all of the reports or did you write a program to convert them to SSRS?  What tools did you use? What method/process did you use?  Did you create any shortcuts? What where some of your lessons learned?  As an interview question how would you explain the process? Any Tips? Thank you for any advice.
0
 
LVL 27

Assisted Solution

by:planocz
planocz earned 333 total points
ID: 36596738
About 90% of the reports that I was working with was landscape and Header and footer with sum totals, groups, etc.. Basically made a base templet of a standard report. Then  by taking the base templet  I would adjust the templet to match the CR report and save and test it. Then repeat the route again for each report. SSRS is still in it's infant stage compared to CR. So some of the SSRS reports I had to use vb.net code in the Code tab on the  SSRS report to complete some of the functions, etc to match the CR report. I learned a lot from that and found that with a little time you can match the reports and feel that you will not have any problems with the new reports in there new SSRS home. :)
0
 
LVL 1

Author Closing Comment

by:SPLady
ID: 36596805
Thank you :)
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Crystal Reports Version 7 4 27
Crystal Reports 12 35
Find results from sql within a time span 11 32
PROPERCASE SCRIPT IN SQL 3 7
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question