Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

too many pages

edited February 2003 in General
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

Comments

  • edited February 2003
    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.
  • edited February 2003
    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

This discussion has been closed.