break after every group, except last one?

[jrmugz]

Greetings,

I have a report that is doing what I want it to as far as having a page break after every group.

The problem is, after the last group, I want the grand totals to appear on the same page (as the last group, assuming it would fit), not on a separate page.

The grand totals are in the report footer for the record.

Any suggestions on how I would accomplish this?

Thank you,
Jim

 

[isladogs]

Try putting the page break BEFORE each group
Should solve the last page issue - does it mess up page 1?

 

[arnelgp]

if you have a Page Break control there, Remove it.
Click on the the GroupHeader band.
on it's Property->Format->Force New Page->Before Section.

 

[isladogs]

Hi arnel
Always good to 'reinforce' exactly the same point ....

 

[Frothingslosh]

Note quite the same point, actually. You suggested moving the actual page break control, while Arnelgp suggested changing a group property.

Sure, it's nitpicking, but A's solution does seem to be a bit more elegant.

 

[isladogs]

Note quite the same point, actually. You suggested moving the actual page break control, while Arnelgp suggested changing a group property.

Sure, it's nitpicking, but A's solution does seem to be a bit more elegant.

I didn't mention a page break control
Perhaps my explanation wasn't as clear as intended as the elegant solution was exactly what I meant!

 

[Frothingslosh]

Ahhhhhh.

 

[jrmugz]

Arnelgp, your suggestion, worked perfectly!

Thanks to you and everyone else who chimed in to help!

Jim