Work Out Objects Used In Reports

[system]

A couple of years ago, I downloaded a report with some vba in it, that looped through all reports in a folder and catalogued the objects and filters used in those reports. I have managed to lose this report, and wondered if anyone had a copy that they could supply, or tell me where i can find it?

Andy

---

AndyV (BOB member since 2004-01-16)

[system]

Hi Andy,

Do you happen to remember the name of the report/utility?

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Yep, better than that, you can download it here.

List objects used in a series of reports

Author: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1343]Dwayne Hoffpauir, EDS[/url] The attached utility will record objects that are used in a series of reports. Usage is as follows: [quote:61cb8b7957="Author's notes"]- Create a temporary directory. - Place all documents (.rep files) to be analyzed in that directory. - Place this document in that same directory. - Open this document, and refresh. - Each document in the directory will be opened, and data provider ob…

Really useful tool. just create a folder on your PC, save the reports you want to analyze in the folder, as well as the utility report, open the report and it will run. It documents, universe, object, filters, classes, security domain etc., etc.

Andy

---

AndyV (BOB member since 2004-01-16)

[system]

Hi Andy,
Other than utility do we need to download anything else?

Thanks,
Zaif

---

zaif235 (BOB member since 2010-06-15)

[system]

No, and the instructions for use are displayed as you open the report. Once you have run it, it creates some variables containing the data, and you can create your own reports if the “pre-canned” ones do not display the data as you want it.

---

AndyV (BOB member since 2004-01-16)