"Force New Page" in "Group Footer" forces "Report Footer" to new page

[sarnyg]

Hello there,
It seems like the queerest thing to go wrong, but I'm trying to produce
a report with the following structure

Report_Header
Group_Header0
Group_Header1
Detail
Group_Footer2 (containts total for header1)
Group_Footer3 (containts total for header0)
Report_Footer (contains overall total)

As I want every Group_Header1 to begin on a new page I have set the
"Force New Page" property to "After Section" but this forces
Report_Footer onto a new page, which i don't want as it is just one
total count. The same occurs if i place a page break control in the
Group_Footer1. I have looked at previous threads which suggest coding
but my acces knowledge doesn't extend that far, any easy
control/property ideas?

 

[BruceM]

Have you tried "Before Section"? The logic of "Before Section" and "After
Section" is not quite clear to me, but this may produce the desired result.

 

[sarnyg]

Thanks for your reply! I have tried this option but it produces a page
break after the Report Header, which i guess I could produce a whole
page cove for the report in this case, unless anyone out there has the
answer?!

 

[BruceM]

I have done some experimenting. I'm sorry to say that as far as I can tell,
this is a problem without a solution. Perhaps there is a code solution, but
I don't know what that may be.