Event based report

[pip7kids]

Hello
Using Crystal Enterprise version XI - can you trigger a report to run when a value in the database has changed and how please.

 

[Turkbear]

Hi,
Business Objects Enterprise ( not Crystal Enterprise, by the way) has a 'Schedule on Event' function that can be configured to run when a file appears in a particular file system location so you would need some kind of trigger in your database that, upon the data changing that you are interested in, creates that file.

( see this thread for more ideas:
thread782-1620835 )



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Turkbear]

Hi again,
My additional note about the program being Business Objects Enterprise and not Crystal Enterprise was snarky, sorry - blame a pre-coffee morning - after all, the forum is named Business Objects:Crystal Enterprise - the name of the program changed with version XI.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[pip7kids]

Thanks for this - sorry about the naming and keep drinking the coffee.

Regards

 

[hilfy]

Note that there is a "trick" to using file-event-based scheduling. The event server does not check the date of the file, instead it checks for the file's presence. In order for it to register that a new file has appeared, the previous file must have been deleted AND it has to be gone for at least one polling cycle of the event server, which I believe defaults to 2 minutes.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.