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!

Suppress Group Header when top of page

Status
Not open for further replies.

cspuckett

IS-IT--Management
Feb 6, 2009
27
US
I have two groups in my report. Let's call them Company (group 1) and Division (group 2), with detail division records in the main report.

Group 2 Header is blank, but I want to leave it in because it provides a nice visual break between the Group 2 footer subtotal and the start of the next set of Detail records.

However, I want to suppress the Group 2 Header if it is the very first line on the page. Because the number of detail lines can change, the Group 2 Header could be the first line on page 3, page 5, or never. It just seems to happen enough times to where I'd like to conditionally suppress it.

Any thoughts? I can probably figure it out if I have a line count, but I was wondering if there was another way?
 
Create two formulas:

//{@true}:
whileprintingrecords;
booleanvar flag := true;

//{@false}:
whileprintingrecords;
booleanvar flag := false;

Place {@true} in the page FOOTER, and place {@false} in the group #1 header, the detail section and in the report header.

Then go into the section expert->group header #2->suppress and enter:

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

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top