• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 537
  • Last Modified:

Crystal reports header footer suppresion on report footer

I have an order acknowledgement report that I am attempting to put terms and conditions on.  I added a large text block to the report footer with the terms (it is just under a full page).  The report footer is marked with 'new page before' and 'keep together'.  I have attempted all types of formulas for the suppresion of the page headers and page footer including: pagenumber=totalpagecount and onlastrecord with no success.  If I just suppress after page 1 then this works fine for single page reports. This is crystal reports 10.
0
darsys
Asked:
darsys
  • 2
  • 2
1 Solution
 
LinInDenverCommented:
Are you just trying to force a new page between your results and the disclaimer?

Have you tried "new page after" on the last section before your report footer?
0
 
mlmccCommented:
Try this

Add a second report footer section
  Right click the report footer in the left margin
  Click INSERT SECTION BELOW
Move your disclaimer to that section
In RFa add a formula
WhilePrintingRecords;
Global BooleanVar SuppressPageHeader;
SuppressPageHeader := True;
''

In the report header add a formula
WhilePrintingRecords;
Global BooleanVar SuppressPageHeader;
SuppressPageHeader := False;
''

Suppress the page header and footer with

WhilePrintingRecords;
Global BooleanVar SuppressPageHeader;
SuppressPageHeader

mlmcc
0
 
darsysAuthor Commented:
This report is printing for a single acknowledgement which should make this even easier.

LinInDenver
  I tried the 'insert page after' in the previous section and still have the same issue.

mlmcc
The acknowledgements have variable numbers of pages.  So the report may be 1 page then the terms or 3 pages then the terms.  I need the page header and footer on all of the acknowledgement pages.
0
 
mlmccCommented:
WHere are the terms?
If they are in the report footer then the idea should work.

mlmcc
0
 
darsysAuthor Commented:
Sorry for making some assumptions about the solution before really looking at what you were doing.  I really appreciate the help.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now