Report Schedule on Database Change

[RedHeadedStepITChild]

I am using Crystal Reports and Crystal Reports Server XI connecting to DB2 (AS400) database via ODBC (IBM Client Access driver).

I have a report showing open PO's for items sent out to be chromed. This report is scheduled to run once a day (in the morning) and is exported to .PDF and emailed to the end-user.

The report runs fine, except we are now in our extreme busy season. The user has asked if the report can be sent to her whenever our procurement group opens a new PO.

In other words, can this report be scheduled to run whenever a change to a designated field is made (i.e. a new PO number is added to the database)?

The way that I would like to do this is to have DB2 trigger the report. I'm not sure if that is possible, and if it is, I'm not sure how to go about it. Another idea that popped into head, is to have the report run every 10 minutes or so, and if there any new additions to the report, export and email. If the report is the same, don't do anything. Is this possible?

I hope this message finds you all well.

Sincerely,

Jason

 

[IdoMillet]

I don't believe Crystal alone can do this. There are 3rd-party Report Managers (see list at

http://www.kenhamady.com/bookmarks.html)

that can address this need.

One option is to use my Visual CUT software:
Schedule the report to run and burst every 10 minutes. This means each PO selected into the report (you could impose a selection criterion to include only PO's from the current date) would become a separate dynamically named pdf file that gets emailed to the appropriate end user.

By using the "Skip_Recent:2880" command line argument, you can instruct Visual CUT to skip processing for any PO that already has a pdf file younger than 48 hours (2880 minutes) in the export folder.

There is another option for achieving the same effect using Visual CUT logging to an ODBC target. However, the Skip_Recent approach requires the least amount of setup.

hth,
- Ido

view, email, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com