RB keeps printing pages

rbuser

Hi all,

I am creating a report with regions to make a layout.
Now, some regions have DBcharts but other have SubReports. When i try the
preview i see the first page generated but RB is busy with the generation
of the next pages like crazy. It keeps on calculating new pages, but the
report is approximately max 5 pages and the last time i checked it was
generating page 2500.

Does anybody know how i can solve this problem?

I already talked to a other delphi expert and he told it could be a bug in
report builder. We use report builder version 7.04.

Thanks in advance,

Daniel



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

------------------------------------------------------
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.


--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

nardmoseley

RB 10.x includes internal checks that warn you, when it detects a report
configuration that causes infinite page generation.

I recommend updating from RB 7.x



--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Hi Nico and Nard,

Thank you for your replies. We already bought the RB 10 version but it
will cost a lot time to upgrade so we didn't upgraded it. This would be a
good cause.

But on the other hand i tried to do what Nico said. TppReport.AutoStop is
true and i don't have any unassigned pipelines, so this should not be the
problem.

I checked and i used some pipelines more than onse. So
what i did is; i created extra pipelines and assigned them only once.
The problem still exists so this should not be the problem either.



How can i check this? My margin settings are:
Top: 24
Bottom: 24
Left: 24
Right: 24

Can i send you the rtm file to check if the last cause matches the problem
i have?

Thanks in advance,

Daniel




--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Daniel,

1. You need to be sure your margins are within the range of the specific
printer you are using. Every printer has an unprintable area (usually 1/4
inch) around each page. If the margins are smaller than this value, issues
can arrise. Try increasing the size of your margins and see if that helps.

2. Are you perhaps linking multiple datasets in your report? If so, have
you checked your data to be sure you are not getting a Cartesian Product
(i.e. returning every detail row for each master)?

Unfortunately sending the .rtm will not allow us to execute the report on
our machines because we do not have your data. If you can recreate a simple
example with the DBDEMOS database or and subset of your data you can send in
a complete application, we could take a look at it for you. Send the
example to support@digital-metaphors.com in .zip format.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

> Thank you for your replies. We already bought the RB 10 version but it

I would be curious as to how much time it will take. I've never found
upgrading RB to be that difficult.

Edward Dressel
Team DM

rbuser

Hi Nico,

1) Maybe is the word print misused by me because i meant the preview option.

2) I do use multiple datasets but i don't link them. What i have done is
placed 5 regions under eachother and placed them all in the header. In
every region i placed a DBChart or a SubReport. For every DBChart or
SubReport is use a different pipeline.
Every region have the value Stretch = True. This is because some
SubReports in the region have to print 10 or 200 lines.(max 200)

I already did send the rtm file before i read this post. But i hope i can
reproduce the problem with the DBDEMOS database.

Kind regards,

Daniel




--- posted by geoForum on http://delphi.newswhat.com

rbuser

Well, we have report builder integraded in our self made ERP solution. So
before we upgrade everything we need to be sure if every (scheduled)report
works because a lot people in our organisation are counting on the
information.




--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Daniel,

ReportBuilder does use the printer driver to create the preview as well as
the printed output. If you are getting an endless page behavior, you will
most likely see it on screen and on paper.

The next step I would recommend would be to begin simplifying your report.
Try periodically removing regions and subreports from the report and
re-generating it to isolate the component or components that are causing the
problem.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

> Well, we have report builder integraded in our self made ERP solution. So

I understand mission critical stuff and risk reduction--just curious on the
time factor.

rbuser

oh, sorry. I misunderstood your question.

But our lead-developer told me it will cost him 3 days.




--- posted by geoForum on http://delphi.newswhat.com

rbuser

> But our lead-developer told me it will cost him 3 days.

I have over 100 reports. I can not remember when upgrading took more then a
couple hour--mostly with 3rd party recompiles. (Sure, there is checking the
reports, but never had a problem there).

rbuser

Hi Nico,

Debugging the report did the trick!
The problem was i had a region with a subreport in the summary band
because i wanted that region printed as last.

I moved the region to the header band, now the report does work!

Thank you for all your tips and ideas.

Daniel




--- posted by geoForum on http://delphi.newswhat.com