Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppress page header on the report footer

Status
Not open for further replies.

kpiljava

Programmer
Nov 3, 2002
14
PR
My report footer can grow into two pages.The problem now is that the page header comes on the second page of the report footer. How to remove or suppress the page header in the report footer section.
Please help
 
try this

Make your report footer into 2 sections.
The first section has the following formula

@FooterFlag

WhilePrintingRecords;
numberVar FooterFlag := 1;

Place this formula in the first Report Footer section and suppress the section. This way the formula is evaluated just before the footer is printed.

In the report header put this suppressed formula

@initialize FooterFlag

WhilePrintingRecords;
numberVar FooterFlag := 0;

So now you have a flag that will tell the page header when to display.

In the Section Expert for the Page Header, put the folliowing formula in the conditional suppress for the section

WhilePrintingRecords;
numberVar FooterFlag;

FooterFlag = 1;

This will suppress the Page header when the first section of the Report Header is read.

This should work like a charm :)
Jim Broadbent
 
Or try this:

Go to format section->page header->check suppress, and in E-2 formula area add: OnLastRecord

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top