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 Westi 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/Page Footer When Page Is Blank

Status
Not open for further replies.

MSGCR

Technical User
Sep 16, 2004
16
US
Been racking my brain over this one.
I have a report that needs to print duplex when the data meets a certain condition. It also needs a "Page A of B" field. So, when there are 3 pages, a 4th blank page must generate, but I need page text to read : "Page 3 or 3" on the 3rd page instead of "Page 3 or 4".

The report is displaying several Report Footer sections at the end. I don't know how to tell the page footer/header that "this page is blank, suppress header and footer." Any help is greatly appreciated.
 
Whatever means you're using to force the blank page use as the criteria for this.

Another means might be to store the last value in a variable for each page, and if that is still the value in the page header for the current row, then trigger the suppress that way.

-k
 
The following works in 8.5. This assumes that you have a group where some groups are an odd number of pages in length, while others are even.

To create the blank page, insert a second group footer #1b. Format it to "new page before" and "new page after". Also check "reset page number after". Then format GH#1a to "reset page number after" also. Format the higher order GH#1 to "keep together".

Then create a formula:

whileprintingrecords;
numbervar pagecnt;
if onfirstrecord or
{table.groupfield} = previous({table.groupfield}) then
pagecnt := pagecnt + 1 else
pagecnt := 1;

Place this in your page header. Then go back to the section expert->page header->suppress->x+2 and enter:

whileprintingrecords;
numbervar pagecnt;
pagecnt <> pagenumber

Still in the section expert, highlight GF#2b->suppress->x+2 and enter:

numbervar pagecnt;

remainder(pagecnt,2) = 0 and
{table.groupfield} <> next({table.groupfield})

Place Page N of M into your page header.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top