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.

42 Responses to “How to get rid of the blank page at the end of a Crystal report”

  1. Thank you very much

    Like this

  2. Thank you
    It works

    Like this

  3. Cool And Very Good :)

    Like this

  4. Very Very Thanks Sir….MH. Moni, Bangladesh

    Like this

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

    Like this

  6. Glad I googled! Thanks

    Like this

  7. Thanks, this really helped :)

    Like this

  8. This is perfect! Thankyou so much!!!

    Like this

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

    Like this

    • 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

      Like this

      • Would you be able to give an example of a formula based on whether the page number is divisible by 2 or not?

        Like this

        • 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

          Like this

  10. Thank you so much!!! works very well…

    Like this

  11. Worked perfectly, thank you!

    Like this

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

    Like this

    • 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

      Like this

  13. PERFECT! Thank you!

    Like this

  14. U R The Best.
    Thanks

    Like this

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

    Like this

    • 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

      Like this

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

        Like this

  16. Thank you

    In spanish: ¡Muchas gracias!

    Like this

  17. Thank you very much,
    that worked perfectly for me…

    Like this

  18. Thanks buddy, its work….

    Like this

  19. Thanks,
    This work great for me

    Like this

  20. Thank you so much…..

    Like this

  21. thanx

    Like this

  22. Does the job quite nicely. Thanks.

    Like this

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

    Like this

  24. A very useful tip!

    Like this

  25. appreciated it is simple and cool

    Like this

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

    Like this

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

    Like this

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

    Like this

  29. Thanks,
    This worked great for me

    Like this

  30. 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!

    Like this

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

    Like this

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,361 other followers

%d bloggers like this: