Crystal Reports How do I suppress all pages except report footer when page number is being reset by group?

Posted on 2011-05-10
Medium Priority
Last Modified: 2012-06-22
Crystal Reports XI
 I have a report in which I would like to suppress all sections except for the Report Footer on the last page.  The report footer consists of summary totals.  The report itself consists of a mailable letter that can be 1 or more pages (successive pages are different than the first page of each group).  It is grouped by CompanyID and the page number is being reset (intentionally) after every group change.  

I have checked numerous posts and have not yet found one that helps me.  Since I am already conditionally suppressing page 1 or page 2 of letter, I would need something that would work in tandem with this suppression.  

Thank you in advance for your help!
Question by:mctwftech
  • 3
  • 2
LVL 101

Expert Comment

ID: 35733278
I don't follow what you want.

If you want all sections suppressed just suppress them.


Expert Comment

ID: 35736686
What would you like to show and what not?

You can supress all sections except report footer or do you mean all page footer except the last page?
Then go to the section expert > page footer, tab the supress tab and press the X-2 button next to supress and enter "Not OnLastRecord"

If this doesn't help please clarify yourself.

Author Comment

ID: 35736871
What I need to do is suppress everything but the report footer when I print the last page of the report.  OnLastRecord suppresses pageheader a on the last record also which in this case is also the page before the report footer.  

Page header a;  I suppress when PageNumber > 1
Page Header b: I supress when PageNumber = 1

When I added the report Footer (to be only printed at the end), it prints on a new page but PageHeader A (which is a letter form) also prints with the Footer with the same data as the page before.

I can't use Total pages because I reset the page number with the group.

Does this help at all?
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.


Accepted Solution

jdg556 earned 2000 total points
ID: 35737164
I think I got something for you.

make the following formula called "footer":

global numbervar rank; 
global numbervar rank2; 
global numbervar rank3; 

rank2 := rank ;
rank := rank + 1;
if OnLastRecord then rank := rank + 1000;
rank3 := rank-rank2;

Open in new window

then add in your section expert the supress variables like:
Page Header b: I supress when PageNumber = 1 or {@footer} > 1

Hope this helps!

Author Comment

ID: 35737692
jdq556, you are a genius.  Works like a charm.  

Author Closing Comment

ID: 35737712
thank you so much.  You are a genius!   Works like a charm!

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Loops Section Overview
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Suggested Courses
Course of the Month15 days, 3 hours left to enroll

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question