thementornetwork
MIS
Right now I am manually capturing the start time of a report and end time of a report by looking at the clock.
It does not take too much effort to get a start time but getting an accurate end time can be a pain as I have to constantly flip back and forth between the stuff I am working on and the report I am running to see if it has finished generating.
Recently I have to do a bunch of performance comparisons between various Crystal Reports and this process has become even more tedious.
Is there a way to write a formula that could capture the exact start time when I hit the Refresh Data button as well as the time the report finishes to generate. It would be even better if there is a way to capture the break down of the duration of Accessing Database time and the duration of Reading Records time.
Or is there any software out there that could do that for me?
We are running Crystal Reports against a Cache DB. Thank you.
It does not take too much effort to get a start time but getting an accurate end time can be a pain as I have to constantly flip back and forth between the stuff I am working on and the report I am running to see if it has finished generating.
Recently I have to do a bunch of performance comparisons between various Crystal Reports and this process has become even more tedious.
Is there a way to write a formula that could capture the exact start time when I hit the Refresh Data button as well as the time the report finishes to generate. It would be even better if there is a way to capture the break down of the duration of Accessing Database time and the duration of Reading Records time.
Or is there any software out there that could do that for me?
We are running Crystal Reports against a Cache DB. Thank you.