To retrieve On-Demand report run duration

[sasa888]

Hi all, I would like to know if there is a way to retrieve report run-time duration for on-demand report? Thank you!

 

[ShortyA]

Hi sasa888,
you can set this up in the report so that the elapsed time of the report is shown in the footer. I have used this several times but another method that has proven successful is using APOS (

http://www.apos.on.ca)

KPI product. It collates stats from your CE installation on a regular basis including the elapsed time of the report. This can then be accessed from Crystal Reports.

To write the elapsed time in the report do the following:
Create a formula called "ReportStart" and place it in the report header. It should contain :

Shared DateTimeVar Start_Time:=datetime(DataDate,DataTime);

Then insert a blank subreport in the report footer with the following formula in its header:

Shared DateTimevar Start_Time;
Local DateTimevar End_Time:=DateTime(DataDate,DataTime);

datediff("s",Start_Time,End_Time);

This will show the number of seconds the report took to run. Where "s" is used above you can change this to use minutes or hours..have a look at the help file for more on the options here.

If you are using CR9 or above I believe you can tidy it up by using DateTimeDiff(date1,date2) and this produces an output of "xx days, yy hours, zz minutes and aa seconds".

Hope this helps.
ShortyA

 

[cmmrfrds]

sasa888, doesn't CE10 track on demand reports in the Audit Table? I am interested to know, since I was assuming the duration would be tracked. If not, have you talked to BO tech support about it?