Click here to Skip to main content
15,850,548 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Guys,

Hope you can help me on this. I have a Crystal Report File and I want to know what's the name of the Stored Procedure that is being used on the Report. All I have is the Crystal Report File.

Is there a code in c# or vb to retrieve the SP being used? Is it possible?

TIA!
Posted

1 solution

You can use "Database" Class:

"Use this class to get the collection of Tables and the collection of TableLinks from a report. Retrieve a Database object through the Database property of the ReportDocument object."

http://msdn.microsoft.com/en-us/library/ms225639%28v=VS.90%29.aspx[^]
 
Share this answer
 
Comments
bryan paling 28-Jul-11 0:07am    
hi Markos, what property of the Tables collection is the stored procedure? can you assist me on how to do it please?
chemark 28-Jul-11 2:42am    
Here is an example in VB:

CType(myReportDocument,CrystalDecisions.CrystalReports.Engine.ReportDocument).Database.Tables.Item(0).Location

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900