Counting runtimes

[lwinstead]

Is there a way to record how many times a report has been run, either as a formula, or a subreport, or something else? I tried having a counter that advances after the records are read, but its not working, and I'm just not that advanced enough to know why. Any ideas out there? Thanks!

<<<<[flux]>>>>

 

[Kebabmeister]

The way I have achieved this is by having all users launch the reports from an access database. This allows me easy version control and allows me to keep usage data.

 

[lwinstead]

Keba,

Thanks for the info. I was fearing that Access was the answer, but it looks like there isn't any other practical way. Thanks again for the quick answer!

<<<<[flux]>>>>

 

[rosemaryl]

Dear Winstead,

There is another option. If you base the report on a stored procedure you can have the stored procedure insert into a table each time it is run the userid and datetime stamp and so on, then the next part of the stored procedure returns the records for the report.

Obviously you would have to create a table, with columns such as Report Name (which you know since you are running the stored procedure and can set this, the user, and the datetime stamp (in SQL SERVER GetDate()).

In crystal when you base a report upon a stored procedure you can do pretty much what you want in the beginning of the procedure as long as at the end you return a recordset. Then you could insert a sql expression that counts the number of times the report was run by that user.

Keep in mind that a refresh is a "print" in this instance so each time they refresh the report it would insert a record.

Regards,

ro

Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762