Managing group headers

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

Hi,

Having a problem with an Access2000 report, and I hope someone can help.

I have quite a few levels of grouping, with details at the lowest level as
you would imagine. I want some of the group headers (say level 2 to 4, where
level 1 is the highest level and level 5 is the detail, if you follow me) to
repeat at the top of each new page. I have this working almost correctly,
except that the headers sometimes appear at the bottom of a page without any
associated detail record. They are then repeated along with the details on
the following page.

How can I suppress the printing of the group headers, in the case where
there isn't going to be room for at least one detail record on the same
page? The sort of logic I'd like would be:

if(can't fit a detail record on after this set of group headers) {
start a new page
}

I'm very grateful for any advice, so thanks in advance.

Ron
 
In sorting/grouping for the group header you can specify
to keep with first detail and others.
Hope this helps.
Fons
 
The perfect Usenet response: short, easy to understand, and fixes the
problem completely in just about 2 minutes!

Thanks very much, Fons.

For your information, I am updating a report in a database I wrote for a
charity that helps old people, so you should feel good about yourself for
helping them as well as me.!
 
Glad it helped. If you need any further help feel free to
contact me at my email (e-mail address removed)
Fons
 
Back
Top