[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 511
  • Last Modified:

Crystal Reports paging issue

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.

  • 2
  • 2
1 Solution
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?
chladeAuthor Commented:
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.
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?
chladeAuthor Commented:
Suppressing the Report Footer did it.  Thanks!

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now