January 12, 2009 
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.
Cool And Very Good
Very Very Thanks Sir….MH. Moni, Bangladesh
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.
Glad I googled! Thanks
Thanks, this really helped
thank u
Thank you!
This is perfect! Thankyou so much!!!
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
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
Would you be able to give an example of a formula based on whether the page number is divisible by 2 or not?
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
Thank you so much!!! works very well…
Very Nice……
Worked perfectly, thank you!
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.
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
PERFECT! Thank you!
Genius!
U R The Best.
Thanks
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.
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
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.
Thank you
In spanish: ¡Muchas gracias!
Thank you very much,
that worked perfectly for me…
Thanks buddy, its work….
Thanks,
This work great for me
Thank you so much…..
thanx
Does the job quite nicely. Thanks.
Thanks, great work, at last i solved my issue.
A very useful tip!
appreciated it is simple and cool
Thanks a lot.. Works great… wasted an entire era to get rid of the extra page…
what a simple solution…
Great tip, thanks so much for posting, don’t know how I’d get anything done in Crystal without posts like this!
Thanks goodness for Google..and your website!!..was battling with this for a couple of hours and voila! Thanks a bunch.
Thanks,
This worked great for me
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!
Hi thanks it works fine.
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