Crystal Reports paging issue

Posted on 2006-03-21
Last Modified: 2012-08-14
I have what probably amounts to two questions but I think they may be interrelated so I'll ask them together.

I am printing invoices using Crystal Reports.  I may be printing more than 1 at a time so I have it grouping by invoice number and set the group footer to "Reset Page Number After".  Also, the group footer is set to "New Page After" so that it starts the next invoice on a new page.

Also, I have a group footer that should print at the bottom of the last page of the invoice.  It is a remittance form.

The first problem is that the "New Page After" setting is causing a blank form to always print at the end.

Otherwise, everything prints fine most of the time.

HOWEVER, if I have an invoice that prints the detail almost to the bottom of the page, it forces the remittance form to the next page.  In this case, it should create a new page (page #2) and print only the remittance at the bottom.

It does do this, but the second page shows page #1 at the top instead of page #2.  Basically, it's fine except that the page number has already been reset.

Any insight into how to clean this up would be appreciated.

Question by:chlade
    LVL 28

    Expert Comment

    For the first problem, you can remedy this by setting the property conditionally.
    Go into the Section Expert, highlight the group footer section, uncheck New Page After, then click the X+2 button to the right of New PAge After.
    Add this line to the editor:

    not onlastrecord

    This will force a new page except on the last grouping.

    For the second problem, is the remittance form the only thing in the group footer?

    Author Comment

    Hmm, that sounded promising but did not work (the "Not OnLastRecord" part).

    I have the group footer split.  The first group footer is a total line that prints right after the group.  The second group footer contains only the remittance.

    I just figured out the second problem.  I had the reset page number logic as part of the first group footer split.  I moved it to the second one and it's now fine.

    But I can't seem to get rid of the blank page at the end.
    LVL 28

    Accepted Solution

    Do you have the Report Footer suppressed?  Suppress it if you don't.
    What section currently has the New Page After set?  GF1a, GF1b, or the parent GF1 section?

    Author Comment

    Suppressing the Report Footer did it.  Thanks!

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now