Menu
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?
944
To do the migration to SSRS, first we create a VS 2005 project, add the ReportViewer, and then add the dataset to be used by the converted SSRS report. We use Crystal Migration Services to convert Crystal Reports to SSRS rdl. Finally you will see the winform Crystal Reports project can be fully converted to SSRS.
As long as compatible versions of OLE DB drivers are installed on the client computer (this is often accomplished automatically by installation of SQL Crystal Reports or another database/client application), SAP Crystal Reports will connect directly to SQL Server with no other intervention required.
Crystal tends to be better at printing reports. The report size and margin settings can cause blank pages in SSRS. Reporting Services will not allow you to pass values from a sub-report to a main report, but it does enable you to nest sub-reports within other sub-reports.
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.
158
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
