Crystal Reports dependencies on Views

Question

I have 200 crystal reports (rpt files), all reports are built by calling the VIEWS. Is there anyway that, I need to know which report is using which VIEW.

Crystal Report version 10

Example:

Employee.rpt depends on V_employee, V_office.

I don't want to open all the 200 reports to find this..please help me..!!!!

Dileep A Dileep A · Accepted Answer · 2011-02-09T18:20:19

If you don't mind doing a little programming, you could write a simple program to output all tables referenced by a report. Here is a C# sample:

    private void PrintTableNames(ReportDocument rpt)
    {
        foreach (Table tbl in rpt.Database.Tables)
        {
            Console.WriteLine(tbl.LogOnInfo.TableName);
        }

        if (!rpt.IsSubreport)
        {
            foreach (ReportDocument subRpt in rpt.Subreports)
            {
                PrintTableNames(subRpt);
            }
        }
    }

Crystal Reports dependencies on Views

2 Answers