Force New Page After Section except for Report Footer

[gumby]

I have a report with the following sections:
Report Header
Page Header
TierGroup Header
SpltiName Header
Detail
SplitName Footer
TierGroup Footer
Page Footer
Report Footer

I want Each TierGroup to force a new page after TierGroup Footer. So
that a new page starts when a new TierGroup Starts. However I do not
want the report footer to be on its own page. So after the last
TierGroup formats I want the report to then place the Report Footer
below it. IS this possible? Let me know if you have any questions as I
tried to explain it the best I could.

Thanks,
David

 

[fredg]

I have a report with the following sections:
Report Header
Page Header
TierGroup Header
SpltiName Header
Detail
SplitName Footer
TierGroup Footer
Page Footer
Report Footer

I want Each TierGroup to force a new page after TierGroup Footer. So
that a new page starts when a new TierGroup Starts. However I do not
want the report footer to be on its own page. So after the last
TierGroup formats I want the report to then place the Report Footer
below it. IS this possible? Let me know if you have any questions as I
tried to explain it the best I could.

Thanks,
David

Set the TierGroup HEADER's ForceNewPage property to
Before Section.
It's located on the Group Header property sheet's Format tab

 

[Marshall Barton]

I have a report with the following sections:
Report Header
Page Header
TierGroup Header
SpltiName Header
Detail
SplitName Footer
TierGroup Footer
Page Footer
Report Footer

I want Each TierGroup to force a new page after TierGroup Footer. So
that a new page starts when a new TierGroup Starts. However I do not
want the report footer to be on its own page. So after the last
TierGroup formats I want the report to then place the Report Footer
below it. IS this possible? Let me know if you have any questions as I
tried to explain it the best I could.

The effect is possible, but it's easier to use ForceNewPage
set to Before Section. This way, you can leave the setting
at None in design view.

Then use a line of code in the tier group header section's
Print event to set it for the remainder of the report:

Me.Section(5).ForceNewPage = 1