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

Widowed Group Header

Status
Not open for further replies.

RichardM140

Programmer
Nov 17, 2003
8
US
Working with CR 11r1.

I have a simple report as follows

RH - Title
PH - DB Field Titles
GH1 - Group Name
D - DB Fields
GF1 - Count of DB Fields
RF - Count of DB Fields
PF - Page Number

The issue I have is that I would like the header to stay with the first detail record.

The report prints something like this.

Title
DB Field Titles
Group Name 1
DB Detail Line 1
DB Detail Line 2
DB Detail Line 3
DB Detail Line 4
DB Detail Line 5
Group Footer 1 Total
Group Name 2

<small white space>
<page break>

DB Detail Line 1
DB Detail Line 2
DB Detail Line 3
Group Footer 1 Total

I have the "Keep Together" checked for RH, GH1, D, GF1 & RF, which doesn't seem to work. I think the issue may be that one of the DB fields is a comment that I have marked as "Can Grow".

I found a formula on this site that helps fix the issue, but it required that I know how many detail lines I will have. I do not know how many will be on any given page due to the "Can Grow" boxes.

Does anyone have any suggestions?

Thanks

Richard
 
Try BDReed's solution in thread149-905801.

-LB
 
That took care of it thanks for the suggestion. I just didn't see that one when searching earlier.
 
The trick is to search by "orphaned" group header,instead of "widowed". :)

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top