Cr 8.5 Defined but Unused Tables

[cliffcor]

I've inherited a large number of reports, many with tables defined in the report that are not actually used in the report. I've been charged with changing the Data Location and having a lot of tables in the rport that are not needed just prolongs the agony of repointing the tables to the new data source. Oh yeah, the client uses a reports folder so the Same Location as Data shortcut isn't an option.

Is there a bulk location setup utility to change the folders of all tables mentioned in a report?

Is there an easy way to id and trim out tables that are not actually used in the report?

Thankjs
Cliff

 

[synapsevampire]

Since you're speaking of folders, I guess that you're using Access or some file based database, in general it's best to include such information.

If you're using ODBC, then the Database->Show SQL Query will reflect the tables required by the report, so you can delete the others. If you're not using ODBC, you can temporarily switch.

Since you'll need to trim out the tables anyway, and this requires opening each report, you can then use the Database->Set Location to repoint the report to it's proper folder. Note that repointing one of the tables should result in a prompt asking to repoint all tables to that new location.

-k