convert/migrate ssrs reports to Crystal reports

[Former Member]

I have quite intresting task in my hand, where i need to provide input to migrate SSRS 2005 report to Crystal Report.

As of not i have understood the mapping of Crystal report to SSRS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Crystal Report Sections

SSRS Sections

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Connection, data source, and parameters

DataSet

Report header and report footer

Page header and page footer

Page header and page footer

Page header and page footer

Row-level data, groupings, and subtotals

Table control

Formulas and custom functions

Expressions, inline code, and custom DLLs

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

I require input for convert SSRS to Crystal Report.

Thanking you in advance.

Raghu Raghavan

[Former Member · Accepted solution]

Raghu,

There are a few tools out there that can convert CR's .rpt files to SSRS's .rdl files... But there is nothing that will take you back the other way.

The simple fact that SSRS allows SOOOO many options that don't have any type of equivalent in CR means there most likely will never be a SSRS to CR converter.

Your best option... Copy the SQL code from the rdl and paste it into a CR Command... At least that way you won't have to waste time linking tables. But other than that... You're going to be building the new reports from scratch.

Sorry,

Jason

[Former Member]

Quite an old topic but still actual and following articles may help somebody in Crystal to SSRS migration and conversion projects

http://www.forrards.com/ConvertingCrystalReportstoSSRSPitfallsofAutomation

http://www.forrards.com/MigrateFromCrystalReportsToSSRS

http://www.forrards.com/ReportingServices