List of Reports By Data Source

[Smithsc]

I'm trying to get a list of all my business object reports that are saved in enterprise and which data source they come from. I've tried using query builder but don't seem to come up with the info reuqired.

Any help would be greaatly appreciated.

Thanks

Stuart

 

[hilfy]

By "data source" do you mean Universe or database? If you mean database, there is no simple way to get that information. However if you look on BOB (

http://www.forumtopics.com/busobj)

there may be something in the downloads area that you can use to pull it.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[briangriffin]

Additionally, if you're talking strictly Crystal Reports there is a link in the Administration Launchpad for Report Data Sources. This is for XI R2, I think something similar is contained within XI 3.x but I don't remember offhand where it is.

 

[Smithsc]

By data source i do mean database. I'm using XI R3 and I don't think there is anything like the Admin Launchpad. I've found the Query builder but I can't seem to get the server name in a query. Any help in that respect would be great.

thanks

Stuart.

 

[hilfy]

The issue with trying to do it in Query Builder is that the database info is stored in a set of objects inside the InfoObject - one per table. So, you really need to use the SDK to run the query so that you can walk through the information to get to the pieces you need. That's why I recommended checking the downloads on BOB - they have lot of Excel templates that use the SDK through VBA to do this type of thing (although I'm not absolutely certain whether they have this particular functionality.)

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.