We have more than 500 Crystal Reports that are based on Stored Procedures. We want to determine the Stored Procedures names associated with each Crystal Report without opening each and every report.
Does anyone know any query or API to retreive the SP names linked with Crystal Reports.
rajneeshsharma (BOB member since 2008-05-23)
Has anyone found a solution to this ? we are in the same situation; lots of Crystal Reports, and I’d like an SQL query or a way to list all the SP’s that we have running from our Crystal reports, is this possible ? (BO XI R2 SP3).
Regards,
Veronica
Veronica (BOB member since 2002-11-22)
Using the Crystal Reports SDK you can extract the SQL String stored in the report`s database object(s).
It`s relatively straight forward if your a programmer.
ABILtd 
(BOB member since 2006-02-08)