Using Crystal runtime to get datasource name

[rjoubert]

We have around 700 Crystal report files (using Crystal 2008). I'm looking for a way to use the Crystal runtime to iterate through all 700 rpt files to list all datasource names (including subreports). While searching for a solution, all I see are posts on how to change the datasource/connection at runtime. Is it not possible to just get the datasource name? Thanks in advance...

 

[rjoubert]

I'm making progress on this. I referenced the CrystalDecisions.CrystalReports.Engine DLL, loaded the report into a ReportDocument object, then accessed the ReportDocument.Database.Tables(0).Location. This gives me the name of the stored procedure that is called by the report. Now I just need to add some logic to account for subreports.

 

[hilfy]

I have code on my website that might help with this. See

http://www.dellstinnett.com/sample_code.html

and look for the Crystal Documenter application. It does one report at a time, but could be easily modified to do what you need.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com