Solved

Crystal Report 10 to SQL Server SSRS 2008R2

Posted on 2011-09-24
8
1,023 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 
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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

734 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