I would like to know if there can be a trigger written in Crystal Reports (I know I can write in Oracle Reports), where I can invoke some Oracle stored procedure that will insert some audit records into Oracle Database. That include the name of the report and access time.

 

I heard from a friend that we can not do this, however I feel that there should be some way of invoking stored procedure or just place an insert statement in Crystal reports.

 

Basically I am looking for certain triggering events such as "When Open Report" or "When Close Report".

 

Thank you for looking into this post and thank you for your time.

 

 

 

Thank you,

Viswa