There is a utility here …List objects used in a series of reports … that should serve as an example. It collects detailed information about the objects used in each data provider, but you could simply it to capture the DProv.SQL property.
Dwayne Hoffpauir (BOB member since 2002-09-19)