Hi All ,
i am using VBA to collect the information for a large no of reports.
like using this i am able to know the name of the Variable used in this document.
ThisDocument.DataProviders(1).Columns.Item(1).Name
But i would like to get more information about this
for Example
like whats is the Database table / Database column where this is stored …
Please help
Black_Measure 
(BOB member since 2006-06-07)
I did a search and saw a code like this
For x = 1 To ObjUniverse.Tables.Item(i).Columns.Count
MsgBox ObjUniverse.Tables.Item(i).Columns.Item(x).Name
Next x
Which works when we are using this Univ object …
But when i try this
ThisDocument.DataProviders(1).Tables.Item(i).Columns.Item(x).Name
I get a error … ( It Looks to me that Data Provider does not exposes Tables object ) 
Please help …
Black_Measure (BOB member since 2006-06-07)
This type of “cross-reference” has been discussed before, but I’m not aware of anything being written to deliver it quite yet. Here are two utilities that will do the two parts separately. If that doesn’t meet your needs, you could create the “cross-reference” piece yourself:
List objects used in a series of reports
Document a universe using Excel and the Designer SDK
Dwayne Hoffpauir (BOB member since 2002-09-19)