Data Provider Names

[MedInfoMan]

Is there a way on the report side (without using VBA) to make a table that dynamically lists the names of all the data providers you may have?

I see a function are available for returning the number of data providers, and a function for returning the name of the data provider which returns a particular object, but I don't see something that would allow you to simply list the names of all the data providers with out having to make a custom formula for each.

Thanks

 

[CindyClayton]

I use this sql to get a list of document information. One of the things included is the dataprovider name. It would be simple enough to put the tables in a universe and make a report from the associated objects...

Here is a link to my sql...

http://www.forumtopics.com/busobj/viewtopic.php?t=18532&highlight=objmdocatvar

HTH! Cindy