32

Is there a way to easily convert Crystal Reports reports to Reporting Services RDL format? We have quite a few reports that will be needing conversion soon.

I know about the manual process (which is basically rebuilding all your reports from scratch in SSRS), but my searches pointed to a few possibilities with automatic conversion "acceleration" with several consulting firms. (As described on .... - link broken).

Do any of you have any valid experiences or recomendations regarding this particular issue? Are there any tools around that I do not know about?

cdonner
  • 37,019
  • 22
  • 105
  • 153
scoob
  • 1,369
  • 1
  • 17
  • 29

7 Answers7

17

I have searched previously for this, with no luck. There does not seem to be any tools available for this conversion, the manual method thereby becomes the only method. And yes, there are consulting firms who will do the manual work for you, but they still do it manually.

Crystal Reports and Reporting Services have different architectural styles, making it a difficult task for a conversion tool, so I view it as unlikely that someone will build one anytime soon.

Carlton Jenke
  • 2,975
  • 3
  • 26
  • 30
  • RptToRdl.Com will get you started with the manual conversion. – John Cruz Jan 06 '12 at 19:47
  • @CDTX - Do you know if anybody has used this site to do conversions? I came across them a while ago but was a bit dubious - no particular reason, but just couldn't find any reviews and was hesitant to hand over that kind of change to somebody on the other side of a .COM, but I'd love to hear that somebody else has used them with success. – SqlRyan Oct 09 '12 at 18:11
  • @SqlRyan, yes, I know a number of fellow developers that have used them. I've used them myself. They are recommended by Microsoft, and the owner even spoke at their 2010 Developers Conference. They've been around for a number of years. – John Cruz Oct 10 '12 at 18:44
10

I work for one of those consulting firms mentioned by Carlton, and let me tell you that we are the only company to have developed an in-house (proprietary) tool that helps us jump start the conversion process from RPTs to RDLs. Our current tool only supports Crystal Rpts 9 and older, and the RDL 2000 and 2005 formats.

I have done several of these conversion projects myself, and there are lots of things that cannot be automatically converted due to the nature of each product. Things like expressions, data source information, and dataset queries just cannot be automagically "translated" by a tool.

Cheers.

Thiago Silva
  • 14,183
  • 3
  • 36
  • 46
6

An alternative would be to use a much cheaper reporting solution which can read Crystal Reports templates, such as (our very own) Java-based i-net Clear Reports (used to be i-net Crystal-Clear).

Note that unlike most solutions, we do NOT lose information such as data source information, formulas, SQL expressions, etc. from the original templates. Even charts are converted quite well.

Also, we now offer a fully functional, free report designer (which can also run reports).

Epaga
  • 38,231
  • 58
  • 157
  • 245
4

My original VB code was converted to C#. See RptToXml.

craig
  • 25,664
  • 27
  • 119
  • 205
2

We're in a very similar situation at the moment. Dozens of crystal reports in place and we're shifting to Reporting Services (mainly for its ease of deployment and more flexible UI for the end user) - our solution is to leave them be, but anything new is being created in RptgSvcs. Ideally we'd translate them, but the .rpt format is too opaque.

Unsliced
  • 10,404
  • 8
  • 51
  • 81
2

In my search I got to know a product of KTL Solutions with the name KTL Crystal Converter which is capable of converting a Crystal report to SSRS.

1

As suggested by Microsoft you may try any of the following migration tools for SAP Crystal Reports to SSRS conversion:

  1. Hitachi Consulting http://www.hitachiconsulting.com/page.cfm?ID=bi
  2. TCS http://www.tcs.com/Microsoft2005Launch/download/Microsoft_Recast.pdf
  3. Sonata Software Ltd. http://microsoftcc.sonata-software.com/html/mcc_bi.htm
  4. KTL Solutions http://www.ktlsolutions.com/t-crystalconverter.aspx
  5. 90DegreeSoftware http://www.90degreesoftware.com
  6. Jeff-Net http://www.rpttosql.com/index.html
  7. Neudesic http://www.neudesic.com
  8. PLUS-IT http://www.plus-it.de
Kasim Husaini
  • 392
  • 3
  • 14