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!

Group Header alone at bottom of page

Status
Not open for further replies.

Frank336

MIS
Aug 6, 2002
41
CA

Hi, (CR8.5 (RDC), VB6, Access 2000)

What can i do if I don't want Group headers to be alone at the bottom of a page with the data on the page after...

Ex. :
I have that structure :

Group Header
Detail
Page Header


When the report print, the result is sometimes :
On page 1 :

Group a
data 1
data 2
...
...
Group d
----New page----
data 1
data 2
...

I dont want "Group d" to be alone. If theres at less 1 line of data, it's OK, but if there is no data at all, I would like the Group D to be print on a new page. Maybe I could use the property "New Page Before", but what formula can I use ?


Thanks,
Frank
 
Go to Report/Change Group Expert... pick the group you want to keep together. Click on the Options button. Check the "Keep Group Together" box.

This yields different results than if you do the Format/Section... Keep together. Mike

Before: After
[morning] [bugeyed]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top