List Tables Reports

[system]

Hello,

I’m looking to list the tables used in all reports in VBA.

Thank you very much for your help.

Best Regards.

Barn.

---

barnard (BOB member since 2009-02-05)

[system]

Welcome to B:bob:B!

If the reports that you have are DeskI reports then the following utility can help you to extract SQL statements from all reports:

DeskI Documents Inspector

Author: Marek Chladny Author notes: Platform: BO XIr2 How to use it: Save all DeskI reports that will be checked into a separate working folder. Open DeskI Documents Inspector in DeskI of BO XIr2. Enable macros (if you get the message that the report contains macros). Use “Select working folder” button and navigate to the folder that contains reports. Type in a keyword in the “search keyword” box. Use * (asterisk) for all. Set what will be searched (variables and formulas, data provider …

Parsing only table names from the whole SQL statements needs to be done as an additional step, outside of the utility.

---

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