We're back in the dark ages. We are supporting a version of Magic that uses ONLY Crystal 8.5. We have about 750 reports that are served thru the app and another 60 or so that are scheduled.
We'd like to know what reports are being used. We've tried creating a stored procedure in Oracle and calling it within the report header (we also tried the footer). It logged the report but wrote an entry for every DETAIL record in the report. That's not what we wanted.
We'd like a single entry that records the user, the report's name, and the date and time it was used.
With that information, we can better manage the growing number of reports. If you know of a way to do this, please help! Thanks.