Report fields in a XIR2 report using VBA Macro Code

[system]

Do a search on BOB in the SDK forum
search keywords : capture objects
Found one here

120×120 10.4 KB

I’ve used Dave’s code to identify the list of objects used in a report (and if I could figure out how to link to the download, I would place that link here). I know almost nothing about VBA so it’s a miracle that I got Dave’s code to work for me. My question is “How would I modify the code to obtain the object’s SQL as well?” I am mainly interested in the Select but some of our objects have Wheres also (and I guess the conditions have Wheres instead of Selects!). TIA KSG …

Also check the downloads section

.

---

haider (BOB member since 2005-07-18)