Calculate report end time

[sraj1]

Hi,

Is there anyway to calcualte or find the report run end time, in report studio?

Actually, I can use the "As of Time" to find when the report started and at the same time I want to find the "end run time" of the report.

 

[blom0344]

Depends on how you define 'end run time'.
A typical report studio report would involve a whole series of actions like compiling the right SQL on the server, sending requests to the database, fetching the data to the server, performing server-based actions (like aggregate filters) and finally generating the output into either html,pdf etc. The run-time might depend heavily on execution of the queries, but it may also involve a heavy load on the server.

Ties Blom

 

[sraj1]

So how can we capture the end time for all these in report studio? Can we capture the above mentioned series individually?

 

[blom0344]

You can run a trace against the source database and store the outcome in a seperate table (at least when you use SQL server) However, you will need to query this trace table again to find out execution time of the queries themselves.
Perhaps the audit component of Cognos can be of some use..

Ties Blom