Search code examples
c#asp.netcrystal-reportsreportdocument

Finding the stored procedure that a Crystal Report is using

I need to retrieve the name of the stored procedure that a crystal report is running. Is there any way to do this in C# using the CrystalDecisions.CrystalReports.Engine.ReportDocument object?

I can't seem to find a property that will give me the stored procedure name.

Is this even possible? I've been through almost all the properties I can think of. The DataDefinition object has collections for the Formula, Parameter, Group Name, and Running Total Fields, but not one for the Database Fields.

Edit: I need to do this programatically, as I have a lot of reports. I need the option of skipping the actual running of the report and just executing the stored procedure that the report would have used. So when the report information is inserted into the database using the program, I want to be able to pull out its stored procedure and store that information separately.

Solution

  • You're going to kick yourself. The SP's are in...

    ReportDocument.Database.Tables

    DataBase

    then Table.Location

    Table

    also don't forget about SubReports...which is another collection of ReportDocuments.