Skip to Content
avatar image
Former Member

Tables used in all my reports

I've got about 120 reports that are using Tables. views, or stored procedures(SQL Server).

I need to make a list of all tables that these reports are using. Is there an easier way to get this info then opening each report up in design view and listing them down?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 17, 2008 at 06:42 PM

    Hi Mike,

    Opening the reports then going into Show SQL Query and copying the From clause from the query and pasting into your documentation would work. Again you do have to open each report.

    If you're bold, you could create a small app in VB that will open the report for you and retrieve the tables, then you could do with them whatever you want.

    Good luck,

    Brian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 06:49 PM

    Hi

    Currently there is no funtionality within crystal reports that could be used.

    Also, there is no third party utility available to do this job.

    The possible workaround is to open up every report and go to Database>>Database Expert and see the list of tables/views/sp's there.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded