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

[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'