C# Pulling query from Crystal Reports

What I have is a project to convert about 200 or so C开发者_StackOverflow社区rystal Reports to SQL, I know there is no real way to do a 1 for 1 direct correlation, so what I want to be able to do is basically open up each report and dissect it for the query it uses in Crystal Reports, does anybody have an example or a place to start?

Thanks!

Try RptToXml:

• Original, VB project
• C# replacement

Another alternative is the PsCrystal PowerShell module

You will have to start by looking at the Field Explorer and go piece by piece though that to see where the logic and SQL are located. The SQL itself can be in the the Database Fields pull down but the rest of the sections may have logic that works on those SQL fields for display. I don't know of any shortcuts from there.

You should be able to use the CrystalDecisions.CrystalReports.Engine to open up the report and view SQL expressions related to each field. Check out : http://msdn.microsoft.com/en-us/library/ms226185%28v=vs.90%29.aspx