Login / Register  search  syndication  about

          George Jensen's Blog

George Jensen on Reporting, Business Intelligence, Crystal Reports, Visual Analyzer, and more.

Supressing the blank page after "New Page After" Group Footer setting

I've worked with Crystal for some time, but there's always been one little thing that sort of bothered me, and I had never took the time to figure out how to deal with it.

If you have a group in your report, and want to start a new page after each grouping, you end up with a blank page at the end of the report.  To get rid of this blank page, all you need to do is to add a simple script to the New Page After property of the group footer:

 

As you can see, we are on the group footer.  In the selection expert, check the New Page After property and then click it's formula button.  In the formula, you just need to compare the resident PageNumber variable with the TotalPageCount variable.  If they are equal, then you are on the last page and the page will suppress.

Specifically, add the following code:

PageNumber = TotalPageCount

And you should be good to go.  No more blank page at the end of the report!

I hope you find this tip helpful.  Thanks for reading!

Jason

What's This?
  
Bookmark and Share

About Jason Buss

   Jason is a senior application developer with Customer FX.



Related Content
   Using an Array - SQL vs Crystal.
In data, an Array is used to store multiple values in a single variable.  I often use Arrays to qual
Posted on Jul 17, 2014 by George Jensen to George Jensen's Blog
 
   CFX Reports Are Updated
I am very happy to back after 19 months of Military leave.  One of my first tasks upon returning to
Posted on Jul 27, 2012 by George Jensen to George Jensen's Blog
 
   Setting up a date range parameter and displaying it in the report
In a recent report, I needed to return data based on a date range selected. That's easy enought to p
Posted on Jul 06, 2011 by Jason Buss to George Jensen's Blog
 
   Setting custom date ranges in Crystal
Recently, I had to develop a report which was to return data within a particular date range. Specificall
Posted on May 27, 2011 by Jason Buss to George Jensen's Blog
 
   Leveling out Users Data.
I am four posts into building a drill down report using Sage SalesLogix Visual Analyzer and Dashboard as
Posted on Dec 01, 2010 by George Jensen to George Jensen's Blog
 
Comments

 

rimonabantexcellence site title said:

Pingback from  rimonabantexcellence site title

June 3, 2013 7:25 AM
 

aom said:

thank you

September 8, 2013 7:57 AM

Leave a Comment

(required)  
(optional)
(required)  
Add
All contents Copyright © 2014 Customer FX Corporation
Customer FX Corporation
2324 University Avenue West, Suite 115
Saint Paul, Minnesota 55114
Tel: 800.728.5783

  Follow @CustomerFX on twitter
Follow the best news, tips, and articles
  Subscribe to Customer FX on youtube
Watch SalesLogix tutorial videos from Customer FX
Login / Register