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.
有没有办法轻松地将Crystal Reports报表转换为Reporting Services RDL格式？我们有很多报告很快就需要转换。
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).
我知道手动过程（基本上是在SSRS中从头开始重建所有报告），但我的搜索指出了一些与几家咨询公司自动转换“加速”的可能性。 （如上所述.... - 链接坏了）。
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?
您是否对此特定问题有任何有效的经验或建议？有什么工具我不知道吗？
9 个解决方案
#1
14
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.
Crystal Reports和Reporting Services具有不同的体系结构样式，这对于转换工具来说是一项艰巨的任务，因此我认为不太可能有人会很快构建一个。
#2
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.
我在Carlton提到的其中一家咨询公司工作，让我告诉你，我们是唯一一家开发内部（专有）工具的公司，它可以帮助我们从RPT到RDL的转换过程。我们当前的工具仅支持Crystal Rpts 9及更早版本，以及RDL 2000和2005格式。
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.
干杯。
#3
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).
另一种方法是使用更便宜的报告解决方案，它可以读取Crystal Reports模板，例如（我们自己的）基于Java的i-net Clear Reports（曾经是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.
请注意，与大多数解决方案不同，我们不会丢失原始模板中的数据源信息，公式，SQL表达式等信息。即使图表转换得很好。
Also, we now offer a fully functional, free report designer (which can also run reports).
此外，我们现在提供一个功能齐全的免费报表设计器（也可以运行报表）。
#5
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.
我们目前情况非常相似。有数十份水晶报告，我们正在转向Reporting Services（主要是因为它易于部署，并为最终用户提供更灵活的用户界面） - 我们的解决方案是留下它们，但RptgSvcs中正在创建任何新内容。理想情况下我们会翻译它们，但.rpt格式太不透明了。
#6
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.
在我的搜索中，我了解了KTL Solutions的产品，其名称为KTL Crystal Converter，能够将Crystal报告转换为SSRS。
#7
0
RptToRdl.Com (http://www.RptToRdl.com) is your best bet.
RptToRdl.Com（http://www.RptToRdl.com）是您最好的选择。
They can do jump-start conversions or full conversions. Pricing starts at $25/report.
他们可以进行快速启动转化或完全转化。定价从25美元起/报告。
#8
0
Check this tool Crystal Migration
检查此工具Crystal Migration
Also they have a video explain this on youtube
他们还有一个视频在youtube上解释这个
#9
0
As suggested by Microsoft you may try any of the following migration tools for SAP Crystal Reports to SSRS conversion:
根据Microsoft的建议，您可以尝试以下任何用于SAP Crystal Reports到SSRS转换的迁移工具：
- Hitachi Consulting http://www.hitachiconsulting.com/page.cfm?ID=bi
- 日立咨询公司http://www.hitachiconsulting.com/page.cfm?ID=bi
- TCS http://www.tcs.com/Microsoft2005Launch/download/Microsoft_Recast.pdf
- TCS http://www.tcs.com/Microsoft2005Launch/download/Microsoft_Recast.pdf
- Sonata Software Ltd. http://microsoftcc.sonata-software.com/html/mcc_bi.htm
- Sonata Software Ltd. http://microsoftcc.sonata-software.com/html/mcc_bi.htm
- KTL Solutions http://www.ktlsolutions.com/t-crystalconverter.aspx
- KTL Solutions http://www.ktlsolutions.com/t-crystalconverter.aspx
- 90DegreeSoftware http://www.90degreesoftware.com
- 90DegreeSoftware http://www.90degreesoftware.com
- Jeff-Net http://www.rpttosql.com/index.html
- Jeff-Net http://www.rpttosql.com/index.html
- Neudesic http://www.neudesic.com
- Neudesic http://www.neudesic.com
- PLUS-IT http://www.plus-it.de
- PLUS-IT http://www.plus-it.de
#1
14
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.
Crystal Reports和Reporting Services具有不同的体系结构样式，这对于转换工具来说是一项艰巨的任务，因此我认为不太可能有人会很快构建一个。
#2
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.
我在Carlton提到的其中一家咨询公司工作，让我告诉你，我们是唯一一家开发内部（专有）工具的公司，它可以帮助我们从RPT到RDL的转换过程。我们当前的工具仅支持Crystal Rpts 9及更早版本，以及RDL 2000和2005格式。
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.
干杯。
#3
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).
另一种方法是使用更便宜的报告解决方案，它可以读取Crystal Reports模板，例如（我们自己的）基于Java的i-net Clear Reports（曾经是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.
请注意，与大多数解决方案不同，我们不会丢失原始模板中的数据源信息，公式，SQL表达式等信息。即使图表转换得很好。
Also, we now offer a fully functional, free report designer (which can also run reports).
此外，我们现在提供一个功能齐全的免费报表设计器（也可以运行报表）。
#4
#5
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.
我们目前情况非常相似。有数十份水晶报告，我们正在转向Reporting Services（主要是因为它易于部署，并为最终用户提供更灵活的用户界面） - 我们的解决方案是留下它们，但RptgSvcs中正在创建任何新内容。理想情况下我们会翻译它们，但.rpt格式太不透明了。
#6
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.
在我的搜索中，我了解了KTL Solutions的产品，其名称为KTL Crystal Converter，能够将Crystal报告转换为SSRS。
#7
0
RptToRdl.Com (http://www.RptToRdl.com) is your best bet.
RptToRdl.Com（http://www.RptToRdl.com）是您最好的选择。
They can do jump-start conversions or full conversions. Pricing starts at $25/report.
他们可以进行快速启动转化或完全转化。定价从25美元起/报告。
#8
0
Check this tool Crystal Migration
检查此工具Crystal Migration
Also they have a video explain this on youtube
他们还有一个视频在youtube上解释这个
#9
0
As suggested by Microsoft you may try any of the following migration tools for SAP Crystal Reports to SSRS conversion:
根据Microsoft的建议，您可以尝试以下任何用于SAP Crystal Reports到SSRS转换的迁移工具：
- Hitachi Consulting http://www.hitachiconsulting.com/page.cfm?ID=bi
- 日立咨询公司http://www.hitachiconsulting.com/page.cfm?ID=bi
- TCS http://www.tcs.com/Microsoft2005Launch/download/Microsoft_Recast.pdf
- TCS http://www.tcs.com/Microsoft2005Launch/download/Microsoft_Recast.pdf
- Sonata Software Ltd. http://microsoftcc.sonata-software.com/html/mcc_bi.htm
- Sonata Software Ltd. http://microsoftcc.sonata-software.com/html/mcc_bi.htm
- KTL Solutions http://www.ktlsolutions.com/t-crystalconverter.aspx
- KTL Solutions http://www.ktlsolutions.com/t-crystalconverter.aspx
- 90DegreeSoftware http://www.90degreesoftware.com
- 90DegreeSoftware http://www.90degreesoftware.com
- Jeff-Net http://www.rpttosql.com/index.html
- Jeff-Net http://www.rpttosql.com/index.html
- Neudesic http://www.neudesic.com
- Neudesic http://www.neudesic.com
- PLUS-IT http://www.plus-it.de
- PLUS-IT http://www.plus-it.de