too many pages

rbuser

I have a simple report that should have only one page. When I preview the
report, it displays the one page, but at the bottom left it says
"Calculating page nnnn for report Report" where nnnn goes on forever! I can
stop it by clicking on cancel. The name of my report is not "Report" so I'm
puzzled!

Any help would be greatly appreciated. I'm sure this is something simple.

Thanks,

Brian

rbuser

Message from Tech-tips newsgroup posted below.

--
Ed Dressel
Team DM


------------------------------------------------------
Article: TroubleShooting: Report Prints Endless Pages
------------------------------------------------------

Occasionally, we have customers state that their reports are in some
infinite state where page after empty page prints forever.

There are a few items to check when this occurs.

The TppReport.AutoStop property is the first thing to check. If this is
false when the DataPipeline property is unassigned, the endless report
will be the result. AutoStop is automatically set to True when
DataPipeline is set to nil, but it is possible to set it back to False.
Check for instances in your code where you might have created this
condition.

Another thing to check is that all subreports in your report have their
DataPipeline set. When a subreport does not have its pipeline set, you
will sometimes see a condition where the first detail record prints and
then you get blank pages.

Another, non-data related cause can sometimes be your margin settings.
If you have stretching bands that need to overflow to the next page, if
your margins are too tight, sometimes the report engine will endlessly
overflow to the next page trying to fit the overflow material.

Still another cause might be having a statically positioned control, set
to ReprintOnOverFlow, in the same band with a stretching control. For
instance, if you have a memo set to stretch and in that same band, a
label control set to ReprintOnOverFlow, then on every page after the
first, the memo will begin to print after the label control. If the
label is placed low enough that the memo has no room to print, the
report will forever be trying to print the overflowing memo on the next
page.

rbuser

The TppReport.AutoStop property proved to be the problem. Not sure how that
happened because my other reports did not have same problem.

Thanks for your help!

Brian