How do I determine which reports use a given data source?

[Former Member]

total newbie and completely lost on this site so forgive me if this is an inappropriate question but I'm in a pickle -

How do I determine which published Crystal Reports use a given data source?

I have BO XI R2

Thanks

Jamie Simpson

[indraneelchatte · Accepted solution]

You need to connect to the CMS Database to query the CI_INFOOBJECTS table.

You can try this query also " SELECT SI_NAME, SI_PROCESSINFO.SI_LOGON_INFO FROM CI_INFOOBJECTS WHERE

SI_INSTANCE = 0 AND SI_NAME = 'Report Name' "

[Former Member · Accepted solution]

You need to connect to the CMS Database to query the CI_INFOOBJECTS table.

The CMS database does not contain the CI_INFOOBJECTS table. CI_INFOOBJECTS is a pseudo-table held in CMS memory only. It is not an actual table on the database. CI_INFOOBJECTS can only be accessed via the SDK and Query Builder. One only needs to logon to the CMS and not the CMS database to access CI_INFOOBJECTS.

[Former Member]

Getting closer. I want all records where si_server is equal to 'IVRP01'. Can you give me the correct syntax?

[Former Member]

Invalid object name 'CI_INFOOBJECTS'.

I have object name 'CMS_INFOOBJECTS' but no fields named SI_KIND, SI_NAME, SI_PROCESSINFO.SI_LOGON_INFO in it

DB is SQL server

[Former Member]

Ok. By Query Builder, I meant Business Objects' Query Builder.

You should see a link for this on the left-hand-side of your Administration Launchpad.

You could also use the following URLs;

http://boserver/businessobjects/enterprise115/WebTools/websamples/query/logonform.aspx (for .NET/IIS)
http://boserver:8080/businessobjects/enterprise115/adminlaunch/query/ie.jsp (for Java)

Also, the SQL used in (BO's) Query Builder is db independent.

[Former Member]

Jamie

The Vendor's on DB determines the ODBC Login & Password. They should be the one's telling you the parameters of login and password. You should know what the server name is.

First Page of the ODBC ( System DSN ) usually has the following:

Name:

Description:

Server:

2nd Page

Login ID:

Password:

3rd Page:

Change the default database to:

( This is where the vendor should give you which DB to attach to )

[Former Member]

Let me rephrase my question.

On my Crystal server I have many published reports and many configured ODBC data sources, all working fine.

However we are updating the DB schema for one of the data sources - call it ZZXXCC data source - and I want to know which published reports use the ZZXXCC data source so I can confirm they all work with the new schema before I go live?

Thanks

Jamie

[Former Member]

Try this query in Query Builder:

SELECT SI_NAME, SI_PROCESSINFO.SI_LOGON_INFO FROM CI_INFOOBJECTS WHERE SI_KIND = 'CrystalReport'