How to get rid of the blank page at the end of a Crystal report

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.

15 Responses to How to get rid of the blank page at the end of a Crystal report

  1. Asif says:

    Thanks buddy, its work….

  2. facebook says:

    Thanks,
    This work great for me

  3. Basu Malipatil says:

    Thank you so much…..

  4. erkan says:

    thanx

  5. Joe Stusnick says:

    Does the job quite nicely. Thanks.

  6. Kumar says:

    Thanks, great work, at last i solved my issue.

  7. Prahlad says:

    A very useful tip!

  8. muhammad shoaib says:

    appreciated it is simple and cool

  9. Ankit Jain says:

    Thanks a lot.. Works great… wasted an entire era to get rid of the extra page…
    what a simple solution…

  10. Ed says:

    Great tip, thanks so much for posting, don’t know how I’d get anything done in Crystal without posts like this!

  11. Yram says:

    Thanks goodness for Google..and your website!!..was battling with this for a couple of hours and voila! Thanks a bunch.

  12. Syed's says:

    Thanks,
    This worked great for me

  13. Miriam says:

    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!

  14. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>