Access the "Crystal Reports" Database

[baycolor]

Hi,

I'm using CR XI and CR Server. Database I access is Teradata.

I have a few dozen reports that are scheduled and distrbuted automatically via email. They run at all different times during the week and on the weekend.

I know a notifications area exists in the setup area of a published report. So I can set each report to email me when it fails. But I don't want to set that up for each report.

What I would like to do is create a report that queries the CR database and emails me (once a week) a list of all the reports that failed in the last 7 days.

If this is possible...

1)
Where is the CR database located on my CR server (path)?

2)
Do I need a login and password to it (if so would it be my administrator login and password)?

3)
Are there views to the tables in this database (don't want to query the tables)?

Thanks in advance.

 

[synapsevampire]

Getting into the CRS database isn't the issue, that's easy, but much of it is encrypted.

You'd be better served to post in the Crystal Enterprise forum, and search there, there are some threads about doing things like this.

-k

 

[baycolor]

Thanks I will search and post there.