Can I display how long it takes a report to run?

[jaybar48]

Hi

I would like to compute how long it takes a report to run from the time I click on the refress symbol to when the report finishes and displays on the screen.

Can this be done? If so how?

Thanks,

Jay

 

[chelseatech]

Crystal 9 (and later) has a Performance Information menu item (on the report menu). So you can see this manualy.

If you want it to be in the report, one way I can see is to use a variable, and store the start time of the report in a BeforeReadingRecords variable, and then compare that with the current time in the report footer. But I suspect this method would omit some time like when it is loading the report and connecting to the database.

Some third party schedulers like my cViewSERVER record the start and end times of a scheduled report, and can accumulate this over multiple runs to get an average report processing time.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm