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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supress Page Headers for Cross tabs at end of report

Status
Not open for further replies.

boardgamer

Programmer
Feb 14, 2009
58
US
How can I supress my page headers at the end of my reports that have cross tabs. The problem comes in when my cross tabs have an unknown number of pages. Is there a way to supress page headers in certain sections?
 
A simple solution is to insert a page break before the section containing the crosstab and then use a suppression formula on the page header section:

onlastrecord

The only time this will not work perfectly is if on the last page of the main body of your report you have one detail record showing--then it will have no page header.

A surefire solution is to create two formulas:

//{@false} to be placed in the report header:
whileprintingrecords;
booleanvar flag := false;

//{@true} to be placed in the section containing the crosstab:
whileprintingrecords;
booleanvar flag := true;

Then go into the section expert->page header->suppress->x+2 and enter:

whileprintingrecords;
booleanvar flag;
flag = true; //note no colon

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top