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

Print Preview problems

edited October 2006 in End User
I have a report that prints just fine. It also previews just fine.
However, if I preview it and try to print it from the preview screen itself,
it will print out thousands of pages. In fact Its like it gets in a loop
and prints forever.

I don't know what to do to fix it because the report itself is fine as long
as I don't print from the preview screen itself. Anyone have any idea what
might be causing this?

Thanks,

glenn

Comments

  • edited October 2006
    Hi Glenn,

    First I would recommend updating your version of ReportBuilder to the latest
    version (10.04). This is a free upgrade for registered RB 10.x users.
    Contact info@digital-metaphors.com for upgrade instructions.

    Take a look at the following article. As a test try commenting out all
    event code you have relavant to the report. Perhaps some event code is
    being fired twice and causing this behavior. Also, take a look at the
    following article.

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited October 2006
    Upgrading didn't help the situation but reading the article now to see if it
    helps any...

    Thanks,

    glenn

  • edited October 2006
    I have tried all of the relevant tricks mentioned and still having the
    problem. I would like to restated the fact that this report prints
    perfectly well, just as long as I don't preview the report and print from
    the preview screen. So whatever the problem, it only appears if the user
    previews the report and tried to print from there....

    Any more ideas?

    glenn


  • edited October 2006
    Hi Glenn,

    Have you tried commenting out all your event code? If possible, please
    construct a simple example that demonstrates this behavior and send it in
    .zip format to support@digital-metaphors.com and I'll take a look at it for
    you.

    --
    Regards,

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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.