Crystal Enterprise Query Emails Sent

[jasonhuibers]

We have scheduled 2000 reports VIA email through the CMC. I need to run a query against the crystal database for all successful reports sent by email. Can I do this in Crystal or is there a third party tool?

 

[AndrewBaines]

Few choices:
1) Use auditing - may need to pay extra depending upon your version
2) Use the Instance Manager from the launchpad, though that may show more than you need.
3) Use a query in the query builder to return the necessary information.
4) Send me a PO and I'll write a nice piece of C# to retrieve the information from the CMS.

Andrew Baines

http://www.pursuittechnology.co.uk

 

[MJRBIM]

We use the "APOS Instance Manager" for this kind of work.

Senior Business Intelligence Consultant
Toronto, Canada

SeagateInfo 7 -> Crystal Enterprise -> BOE-XI (R2) / (R3.1) | Crystal ( 7 -> 2008) design | WebI design | Best practices for Java / .Net / Web Services