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.