Print Page | Close Window

Alerts and Triggers

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4498
Printed Date: 02 May 2024 at 1:46pm


Topic: Alerts and Triggers
Posted By: jcrespo
Subject: Alerts and Triggers
Date Posted: 09 Oct 2008 at 11:01am
I am trying to create a report that will send off a trigger once new data is added to the DW table.

I am going off of the insert date in the table. Once there is a new insert date I want the alert to go off and email the report out.

Does anyone know how to do this??

Thank,
JC


Replies:
Posted By: hilfy
Date Posted: 09 Oct 2008 at 2:02pm
You can't do it within the report itself.
 
Are you running your reports through Crystal Server or BO Enterprise?  It would take some programming, but you might be able to set this up if you're using one of them.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: fusion
Date Posted: 10 Oct 2008 at 1:05pm
Hilfy,
Could you explian how to do that if there is a BO Server or Cystal Server?
 
Thanks
 

Posted By: hilfy
Date Posted: 10 Oct 2008 at 1:31pm
BO and Crystal Server both have the ability to schedule based on events.  One of the event types is "File".  This means that it will check specific folder to see if a file exists.  However, it does NOT look at the timestamp of the file, just whether or not it exists now and didn't exist the last time it checked.  You can set the polling interval (how often it checks for the file.)  The important part of this is that the file doesn't exist and then it does, so the file also has to be deleted at some point. 
 
You then schedule the Crystal Report to run based on events.  You have to set the time for it to run - if you want it to run multiple times throughout the day, I would select Hourly, which then gives you the option to run the report every x minutes.  If you schedule with events, it will only run if the event happens and then reschedule itself for x minutes later, but only run if the event happens again.
 
So, if your application can delete the file, do its processing, and then create the file when processing is complete, then you can use this type of scheduling. 
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: fusion
Date Posted: 10 Oct 2008 at 4:28pm
Hilfy,
Thank you for your explanation.
How would you make the file appear and disappear? Is there a need of seperate application to make that happen?
 
Thanks again.

Posted By: hilfy
Date Posted: 13 Oct 2008 at 6:46am
Yes, you have to have a separate application to do that - although I believe you may be able to do something of the sort from your database (I know it can be done from Oracle....)
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window