Tables used in all my reports

[Former Member]

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?

[former_member292966 · Accepted solution]

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

[Former Member]

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