chlade
asked on
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.
Thanks!
Chris
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.
Thanks!
Chris
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Suppressing the Report Footer did it. Thanks!
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?