Talk with the Author
 Crystal Reports Forum : General Information : Talk with the Author
Message Icon Topic: Logging Report Usage Post Reply Post New Topic
Author Message
JToine
Newbie
Newbie
Avatar

Joined: 23 Apr 2010
Location: United States
Online Status: Offline
Posts: 2
Quote JToine Replybullet Topic: Logging Report Usage
    Posted: 23 Apr 2010 at 3:53am
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.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 23 Apr 2010 at 10:13am
You could try modifying the SQL for the report to call the stored procedure before it does the select statement.  In Crystal 8.5, you have the option to Show/Edit query.  In later versions you would have to convert this to a Command as you can't edit the query.  If you ever have to upgrade these reports to a newer version, you would have to rebuild from scratch in order to create the command as modified SQL from 8.5 and earlier doesn't upgrade well.
 
-Dell
IP IP Logged
JToine
Newbie
Newbie
Avatar

Joined: 23 Apr 2010
Location: United States
Online Status: Offline
Posts: 2
Quote JToine Replybullet Posted: 23 Apr 2010 at 10:22am
Dell,
 
Thanks so much for replying.  Your suggestion is exactly what we attempted.  The problem isn't that it doesn't write.  It's that it writes, and writes, and writes for every record that displays in the detail section.
 
We only want a single line entry (User Name, Date, Report Name) to store in the database.  That's enough information to allow us to manage the report volume.
 
If you have any other suggestion, I'm open to it!  Thanks again.  I appreciate your offer.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 23 Apr 2010 at 10:32am
Is your date just a date or is it a date/time stamp?  Is there any way you can modify the stored procedure to prevent duplicates during a single run?
 
-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.031 seconds.