CODEWITHSUNDEEP
sdkcrystal-reportscrystal-reports-2013
dougp
dougp

Reputation: 3087

Automating inspection of Crystal Reports files

I need to extract the SQL queries from many Crystal Reports (.rpt) files. Because of the volume of work, I'd like to script this. But I have been unable to find any information beyond advertising.

I have a license (and have installed) Crystal Reports 2013. I also have a license for Crystal Reports 2016 (that I can install). Does the application ship with the DLLs I need to write a program to inspect the contents of the .rpt files? Or do I need to purchase a license for an additional product? Does SAP Crystal Reports, version for Visual Studio include full SDK support for .rpt files? The documentation I can find doesn't list any Windows version beyond Windows 10 and Windows Server 2016. Is this product still valid?

In Visual Studio, I added a COM reference to Crystal Reports Report Definition Model Library 14.0. It looks like it's close to what is in that documentation, but some of the object methods (like the first one I think I need: ReportDocument.Load()) are not available.

The vast majority of the documentation I can find on this topic is from 10-15 years ago.

Upvotes: -1

Views: 23

Answers (1)

MilletSoftware
MilletSoftware

Reputation: 4001

There are several 3rd-party products that specialize in mass inspection of Crystal Reports. See list here. Some of these tools include the ability to list (and even Find & Replace) SQL statements for Commands.

If you use the Crystal Runtime, and the RAS object model, you can list SQL statements but non-Command (direct connection to Tables/Views/SPs) scenarios would require actually running the reports.

Upvotes: 0

Related Questions