Time elapsed for report to generate 2

[jedoublefunk]

Is there anyway (besides looking at a clock) to determine how long a report actually took to generate?

I'd like to try a few things out on some reports to speed them up as they take a long time to load but I don't want to have to sit and watch the report chug along so I can figure out how long it took to run.

I'm using Crystal XI.

 

[lbass]

There have been some suggestions on this in the past that I was unable to get to work (I might have been implementing incorrectly).

What I do, though, is add the print date and time and data date and time to the report header. If you save the report exactly when it completes, you can see the elapsed time. In some cases, you need to make a small change so that you CAN save the report, e.g., grabbing the boundary of a field and resizing it and then saving it. Still, you have to be there at the time to do this.

If anyone knows a way of doing this where you can automatically see the difference (so that you can leave and come back later), I would be very glad to learn about it.

-LB

 

[IdoMillet]

In Crystal 9 and above, simply select the menu option of:
Report, Performance Information...

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[Harki06]

This really useful. Thanks!

 

[lbass]

Ido, I've seen that, but it's in milliseconds and broken out into categories. So do you consider the total processing time in minutes to be the following?

(
running the query +
reading the database records +
(no of pages formatted * average time to format a page)+
(no of page starts generated*average time to generate a page)
)/1000/60

Now if only there were a way to access this data in a formula!

-LB

 

[IdoMillet]

LB,

I think the information in the Performance Information dialog is actually more useful precisely because it's broken down by processing phases. This lets you identify where the problem is.

Cheers,
- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Yes, I can see that. I guess my mind doesn't work in milliseconds! I wish there were a total. Anyway, do you think my calculation would be correct? Thanks (*).

-LB

 

[IdoMillet]

Hi LB,

I think the page performance could be a question mark (it would depend on whether or not the report has a 'Page N of M' type of content) but the logic looks sound.

It sounds like you are really keen on getting total time statistics. Consider a 3rd-party tool as a solution (for a list of such tools, see

http://www.kenhamady.com/bookmarks.html).

My DataLink Viewer allows you to generate a centralized log showing who (Windows User ID) ran what report on what machine, when, and how long it took.

Cheers,
- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Thanks, Ido--that could be very useful.

-LB