How to get rid of the blank page at the end of a Crystal report
January 12, 2009 15 Comments
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.
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