I have a report that requires seven hours to run. I would like to shorten the runtime. When the report is running I noticed the message which appears at the bottom left corner of the screen. It seems to indicate what type of operation Crystal is doing: Reading Records, Subreport, Accessing Database, Determining Total Page Count. It is this last message that interests me, as it seems to appear each time Crystal reads and processes a record. The report should run faster if I could eliminate whatever is causing Crystal to Determine Total Page Count. I realized that some text objects in the page header contained conditional suppression formulas in the form of

If PageNumber = TotalPageCount ...

I commented out those formulas and reran the report. But it does not seem faster and the message Determining Total Page Count still flashes.

Do all reports need to determine the page count even if there are no formulas that include this function? Does this affect runtime?

If you have Page N of M or Total Page Count anywhere in the report, Crystal has to physically render every page while it's generating the report.  This can cause significant speed issues.  I recommend that you replace "If PageNumber = TotalPageCount..." with something like "If OnLastRecord..."

That simple change doubled the speed.

Thanks!
Jonart