Here is a tip from the Flexible Solutions GP Reports newsletter:
Often when creating a Crystal report for something that needs a new page for each group (like Invoices or Purchase Orders) we use the New Page After option for the Group Footer in Crystal’s Section Expert. This works great, however it prints a blank page at the very end of the report.
To remove this blank page, you can add a formula for the New Page After option instead of simply checking it. Click on the formula button and add the following:
Not OnLastRecord
Save and Close and you’re done. Now everything except the very last group will get a new page after it.
To get future tips like this as well as GP Reports news and promotions, you can subscribe to the Flexible Solutions GP Reports newsletter.
Thank you!!!
LikeLike
Thanks
Good work
LikeLike
very helpfull
LikeLike
Thanks alot
LikeLike
Thanks
LikeLike
Thanks a lot. Really helpful tiip
LikeLike
Thank you so much
God bless you
LikeLike
very good answer
thanks a lot
LikeLike
Thank you very much
LikeLike
Thank you
It works
LikeLike
Cool And Very Good 🙂
LikeLike
Very Very Thanks Sir….MH. Moni, Bangladesh
LikeLike
Had the same issue with a conditionally suppressed group with “new page before” creating a blank page even when the group was suppressed. Trick was to force the same formula used for the conditional suppression into the “new page before” condition.
LikeLike
Glad I googled! Thanks
LikeLike
Thanks, this really helped 🙂
LikeLike
thank u
LikeLike
Thank you!
LikeLike
This is perfect! Thankyou so much!!!
LikeLike
Wow that was really easy to fix! THANKS. Do you have an idea of how to add a “this page intentionally left blank” page, if the last page is an odd number? so I end with an even number of pages.
THANKS
LikeLike
Frank,
I have not done this before, but you may be able to accomplish this by creating a new section at the end of your report and showing/hiding it based on whether the number of pages is divisible by 2 or not.
-Victoria
LikeLike
Would you be able to give an example of a formula based on whether the page number is divisible by 2 or not?
LikeLike
Jeremy,
The following formula will return either a 0 or a 1:
(PageNumber mod 2)
If it returns a 0, the page number is evenly divisible by 2, thus an even page number. If it returns a 1, then the page number is odd.
Hope that helps,
-Victoria
LikeLike
Thank you so much!!! works very well…
LikeLike
Very Nice……
LikeLike
Worked perfectly, thank you!
LikeLike
This Works great if I have a Page Break on one group. How about if I have 2 groups and wanted to Pagebreak. Ex. I have Group by Contractor Name, Contract Number, Terminals
So For a same Contractor, There are more than 1 Contract numbers and for each New Contract has to on a New Page. When i click page break it works great, but after each Contractor i see a Blank Page.
LikeLike
Sak,
What version of Crystal? I just tried this with a report with 2 groups on Crystal 2011 – all I did was check “New Page After” on Group Footer #2. I didn’t need to use the trick in this post or do anything else.
-Victoria
LikeLike
PERFECT! Thank you!
LikeLike
Genius!
LikeLike
U R The Best.
Thanks
LikeLike
Hi,
What if the “New Page After” option is greyed out (and ticked)?
On my report that extra page is always added even after the page footer! And we have set the report footer to be suppressed.
LikeLike
Hans,
Most likely another setting is causing this the New Page After checkbox to be disabled. For example, I just checked New Page After on a section, then checked Read-Only…that disabled the New Page After checkbox, while keeping it checked. You would need to go through each section on your report and see where New Page After is selected and where it would make sense to add the formula as I am describing. It should typically be on the outermost group footer that has the New Page After selected.
-Victoria
LikeLike
Thanks for the quick response. We don’t have any groups on the report and it looks like the New Page After section is grayed out on every single on section.
But I get the drift. I’ll dig through each setting and see which is causing the disabling of the New Page After bit.
LikeLike
Thank you
In spanish: ¡Muchas gracias!
LikeLike
Thank you very much,
that worked perfectly for me…
LikeLike
Thanks buddy, its work….
LikeLike
Thanks,
This work great for me
LikeLike
Thank you so much…..
LikeLike
thanx
LikeLike
Does the job quite nicely. Thanks.
LikeLike
Thanks, great work, at last i solved my issue.
LikeLike
A very useful tip!
LikeLike
appreciated it is simple and cool
LikeLike
Thanks a lot.. Works great… wasted an entire era to get rid of the extra page…
what a simple solution…
LikeLike
Great tip, thanks so much for posting, don’t know how I’d get anything done in Crystal without posts like this!
LikeLike
Thanks goodness for Google..and your website!!..was battling with this for a couple of hours and voila! Thanks a bunch.
LikeLike
Thanks,
This worked great for me
LikeLike
Thanks,
I am fairly new to Crystal and had to plunge in with a series of reports. I encountered this problem and your tip was a lifesaver!
LikeLike
Hi thanks it works fine.
LikeLike
This worked great I was sitting on this stupid report for the longest time try to get rid of that extra page. Thanks so much
Martin
LikeLike