List Tables Reports

[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:

120×120 10.4 KB

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)