Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Alerts and Triggers Post Reply Post New Topic
Author Message
jcrespo
Newbie
Newbie


Joined: 09 Oct 2008
Location: United States
Online Status: Offline
Posts: 1
Quote jcrespo Replybullet Topic: Alerts and Triggers
    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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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


Edited by hilfy - 09 Oct 2008 at 2:02pm
IP IP Logged
fusion
Groupie
Groupie


Joined: 12 Nov 2007
Location: United States
Online Status: Offline
Posts: 93
Quote fusion Replybullet 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
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
fusion
Groupie
Groupie


Joined: 12 Nov 2007
Location: United States
Online Status: Offline
Posts: 93
Quote fusion Replybullet 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.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.