I'm trying to move my crystal reports from a static connection to a BusinessView conenction so I have the ability to change database server in one location instead of having to touch 700+ reports.
In order to build my view I only want to use the tables that those 7 hundered reports use. Has anyone seen or written any code to pull the names of a tables used in a crystal report into a list?
I tohught I could soemhow create an array of file paths for all the *.rpt files in a directory and then create another array of the tables used in the reports.