how to get sql for a list of reports using VBA

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 :us: (BOB member since 2002-09-19)