How to show report execution time in Cognos Report Page Output

[nsaxena]

Hi,

I want to display report execution time in the report page .The report runs in pdf format.We have one summary page where clients wants us to show report execution time .

I tried using the below report functions : Now()- Asoftime() ,but both are giving same time hence difference is showing as 0

*Report execution time : Time when user click on run button of the report till the time pdf output is generated.

[BigChris]

I seem to remember something that was written using Javascript in Cognos 8 to do this sort of thing, but if I remember correctly it needed a prompt screen to trigger the timing. I can have a dig around and see if I kept a reference to it, but it isn't something that I've ever used.

[kvchow]

Hi,

I also faced the same situation and finally i got the solution

You will find all the information in Audit DB,there you will find Run time&report name,Import the table into your FM and add it to your report

Thanks,
Kvchow

[nsaxena]

Hi BigChris,

thanks for replying.Yes even i came across while browsing over net about javascript but could not find it.If you came across such please let me know.

In my report we do not have prompts ,and report runs in pdf format .So in first page of pdf we want to display report execution time.

[MrMerrick]

Thanks for this post.  It helped me dial in the resolution.  I had the layout calculation in the header, but was still getting "0" (zeros).  I had to check the query context for the page to be the same as the list I had generating.