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?
Brian Dong replied
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.