Report Just Keeps on Printing

rbuser

Greetings:

I have a problem I have not seen addressed anywhere. I have a small .dbf
table (about 100 records). Each record has three fields:
Team (Smallint)
Street (String)
City (String)

I am trying to run a simple columnar report listing each record, exactly
like in a DBGrid. My problem is that when I run the report it runs forever,
printing blank page after blank page until finally it overruns the memory.

I am using ReportBuilder 5.56 with Delphi 5. Any ideas?

Many thanks.

Lance Johnson
HelpNET of the Greater Denton Area

The

digitalmetaphors

Please see if the guidlines below might help you solve your problems.

------------------------------------------------------
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. As a test, try setting
DetailBand.PrintHeight to phDynamic. A dynamic height band can overflow to
additional pages as needed.

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.

--
Cheers,

Alexander Kramnik
Digital Metaphors

rbuser

Thanks, Alexander. Changing the margins solved the problem. I was hoping to
get all the data on a single sheet, but that just won't be possible. Asi es
la vida.

Lance Johnson


"Alexander Kramnik (Digital Metaphors)" wrote