Hello All,
I think this topic has been discussed a few weeks ago. I tried to search from the archives but couldn’t find out any info. I would like to create a document on a BO report in excel or in BO.
Dataprovider name, SQL Code and List of Objects used. There could be number of data providers.
Any suggestion would be greatly appreciated.
Thanks
Ravi Pazhani.
Ravi_Pazhani (BOB member since 2002-08-20)
Try this thread in the BOB’s Code section: List Objects Used in a set of Documents
Or this free add-in from Lyon Technologies: Report Documentation Add-In
Andreas 
(BOB member since 2002-06-20)
Dave already provided the VBA code for the same in his ‘Objects used.rep’. This will read all the documents in your userdocs directory and reads your repository and provide you with a crosstab report of all objects used in various reports. You can do any sort of analysis with this macro. A great piece
ksshreeramen (BOB member since 2002-09-08)
This thread also discusses the same topic, with some different approaches. Actually, in all my spare time (yeah, right) I’m working on an improved version.
Dwayne Hoffpauir 
(BOB member since 2002-09-19)
I got some problem with Lyon Technologies Report Document code…
If there are many objects with the same name, it picks up all the objects and duplicates the name. Also it gives the following error
**** ERROR - Some objects not found in universe. Check SQL listing below. ****.
Any thoughts?
Ravi.
Ravi_Pazhani (BOB member since 2002-08-20)