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

January 12, 2009 by Victoria Yudin 50 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.

Crystal Reports, GP Reports code

SQL view to show customer pricing

Dynamics GP Bank Rec table information

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

Gilli Reply March 17, 2016 at 11:09 pm

Thank you!!!

LikeLike
TASHA Reply January 28, 2016 at 4:11 am

Thanks
Good work

LikeLike
ahmad Reply January 19, 2016 at 4:23 am

very helpfull

LikeLike
Inam Ahmed Reply November 16, 2015 at 3:29 am

Thanks alot

LikeLike
tarun Reply June 10, 2015 at 8:19 am

Thanks

LikeLike
Priya Reply April 16, 2015 at 9:32 am

Thanks a lot. Really helpful tiip

LikeLike
Mohamed Bakir Reply April 9, 2015 at 2:45 am

Thank you so much
God bless you

LikeLike
Hnin Wai Reply July 30, 2014 at 12:19 am

very good answer
thanks a lot

LikeLike
Ravi Reply October 25, 2013 at 9:15 am

Thank you very much

LikeLike
Jordi Reply June 20, 2013 at 6:33 am

Thank you
It works

LikeLike
Vanishree Reply February 1, 2013 at 7:17 am

Cool And Very Good 🙂

LikeLike
MH. Moni Reply January 15, 2013 at 12:39 am

Very Very Thanks Sir….MH. Moni, Bangladesh

LikeLike
JC Reply July 12, 2012 at 8:26 am

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
Hollis Reply April 4, 2012 at 11:49 am

Glad I googled! Thanks

LikeLike
Chathu Reply March 30, 2012 at 5:55 am

Thanks, this really helped 🙂

LikeLike
camdeveloper Reply March 5, 2012 at 11:13 pm

thank u

LikeLike
Nick Olsen Reply January 10, 2012 at 10:37 pm

Thank you!

LikeLike
johns Reply December 16, 2011 at 6:40 am

This is perfect! Thankyou so much!!!

LikeLike
Frank Reply October 13, 2011 at 3:57 pm

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
- Victoria Yudin Reply October 14, 2011 at 7:36 am
  
  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
  - Jeremy Reply June 21, 2012 at 4:44 pm
    
    Would you be able to give an example of a formula based on whether the page number is divisible by 2 or not?
    
    LikeLike
    - Victoria Yudin Reply June 22, 2012 at 8:08 am
      
      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
sheng Reply October 10, 2011 at 4:59 am

Thank you so much!!! works very well…

LikeLike
Viviane de Almeida Reply September 1, 2011 at 10:34 am

Very Nice……

LikeLike
Buosi Reply August 31, 2011 at 11:56 am

Worked perfectly, thank you!

LikeLike
Sak Reply August 23, 2011 at 10:28 am

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
- Victoria Yudin Reply August 23, 2011 at 10:37 am
  
  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
ReportWriter Reply June 21, 2011 at 3:07 pm

PERFECT! Thank you!

LikeLike
Ian Mercier Reply March 10, 2011 at 3:40 pm

Genius!

LikeLike
Mohamed Reply January 2, 2011 at 7:37 am

U R The Best.
Thanks

LikeLike
Hans Reply November 24, 2010 at 10:00 am

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
- Victoria Yudin Reply November 24, 2010 at 10:17 am
  
  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
  - Hans Reply November 24, 2010 at 11:31 am
    
    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
Pedro Acosta Reply November 5, 2010 at 12:42 pm

Thank you

In spanish: ¡Muchas gracias!

LikeLike
Shahram Reply September 22, 2010 at 5:32 am

Thank you very much,
that worked perfectly for me…

LikeLike
Asif Reply September 6, 2010 at 7:55 am

Thanks buddy, its work….

LikeLike
facebook Reply July 11, 2010 at 11:17 pm

Thanks,
This work great for me

LikeLike
Basu Malipatil Reply June 15, 2010 at 1:01 am

Thank you so much…..

LikeLike
erkan Reply March 19, 2010 at 9:55 am

thanx

LikeLike
Joe Stusnick Reply March 18, 2010 at 4:29 pm

Does the job quite nicely. Thanks.

LikeLike
Kumar Reply March 1, 2010 at 1:00 am

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

LikeLike
Prahlad Reply December 11, 2009 at 6:19 am

A very useful tip!

LikeLike
muhammad shoaib Reply September 16, 2009 at 1:24 am

appreciated it is simple and cool

LikeLike
Ankit Jain Reply August 26, 2009 at 1:31 am

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

LikeLike
Ed Reply July 28, 2009 at 7:21 am

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

LikeLike
Yram Reply June 17, 2009 at 12:10 pm

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

LikeLike
Syed's Reply April 15, 2009 at 4:09 am

Thanks,
This worked great for me

LikeLike
Miriam Reply March 18, 2009 at 7:40 am

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
- kughan Reply September 2, 2010 at 3:20 am
  
  Hi thanks it works fine.
  
  LikeLike
Martin Tomczak Reply January 26, 2009 at 5:11 pm

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