Positioning Group Footer at then end of the Detail section

[Simon]

I ma struggling to have the only group footer I have display at the end of my
Detail Section. My Detail Section mostly occupies one page only but
occasionally there are be more pages (3 max but most 1 or 2), but there is
sufficient room left for the group footer however it is always forced on to
the beginning of the next detail section on the following page. This is no
good for me at all. I have been trying various settings in the "Sorting and
Grouping" Dialogue box and also the Group Footer Properties to rectify this,
but am having no luck at all. Is there another way to force the group footer
to display end of the Details Section. Incidentally I am sorting on 3 fields
but only have a group footer for the last of these sorted fields values.
Apart from t he footer this gives me exactly what I need in terms of how I
need my data to be presented and ordered.

Many thanks in advance for any help or suggestions you may have.

Regards

Simon

 

[John Spencer]

Check the properties of the group footer
Format Tab: Force New Page
should be set to NONE

Otherwise you can look for a page break control in the group footer. It will
look like a short dashed line and will be aligned flush to the left side of
the report.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Golfinray]

Try changing paper size to the next largest size and see what happens. You
could also try to do a force new page after the group footer.

 

[Simon]

To my embarrassment I found that I had set Force New Page to After Section on
in my Details' Properties tab, so have changed this to None and Force New
Page in the group footer Properties Tab is now set to After Section which
gives m the result I was hoping for!

Many thanks!

Simon