Find all objects used in a report on Deski

[system]

Is there a way to write a macro to create a list of the objects (with the corresponding class/subclass) used in a report in Deski?

brian

---

brieweb (BOB member since 2011-04-26)

[system]

Hi,

Give this utility a try:

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 …

It’s probably not exactly what you need but that’s all what can be done with DeskI reports.

---

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

[system]

I am using XIR3. I encountered the same error as this post where it says “Complie error: Can’t find project or Library”

Tables in Reports

Hi, It looks that some library is missing in the references. Do it again and when you get to the point where you get the error message, go to menu Tools -> References and check which library is not available. There should be written "MISSING: " in the References - Project dialog. Then let us know which library it is. Marek Chladny (BOB member since 2003-11-27)

It first stumbled on the ‘Right’ substring function.

If UCase(Right(MyFile.Name, 4)) = “.REP” Then i = i + 1
^----- Gives error here.

This seems like a standard VBA function. Do I need to point to a dll somewhere?

brian

---

brieweb (BOB member since 2011-04-26)

[system]

Hi,

Try the following:

1. open the utility in DeskI
2. close the DeskI Inspector window using the red X in the upper-right corner
3. hit Al+F11 to open the MS Visual Basic editor
4. go to menu Tools -> References
5. some of the libraries are probably not available/missing
6. if only the Parameter Prompting Library 11.5 is missing, then clear its checkbox and hit OK button
7. then go to menu Debug -> Compile Project
8. if you get no error, the utility should work now
9. close the MS Visual Basic window
10. save the utility in DeskI, close DeskI and re-open the utility

If there are more libraries missing (step 5 above) then post their names here.

---

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