break after every group, except last one? (1 Viewer)

jrmugz

New member
Local time
Yesterday, 18:11
Joined
Apr 4, 2018
Messages
2
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

MVP / VIP
Local time
Today, 02:11
Joined
Jan 14, 2017
Messages
18,209
Try putting the page break BEFORE each group
Should solve the last page issue - does it mess up page 1?
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 09:11
Joined
May 7, 2009
Messages
19,229
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

MVP / VIP
Local time
Today, 02:11
Joined
Jan 14, 2017
Messages
18,209
Hi arnel
Always good to 'reinforce' exactly the same point .... ;)
 

Frothingslosh

Premier Pale Stale Ale
Local time
Yesterday, 21:11
Joined
Oct 17, 2012
Messages
3,276
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

MVP / VIP
Local time
Today, 02:11
Joined
Jan 14, 2017
Messages
18,209
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! :)
 
Last edited:

jrmugz

New member
Local time
Yesterday, 18:11
Joined
Apr 4, 2018
Messages
2
Arnelgp, your suggestion, worked perfectly!

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

Jim
 

Users who are viewing this thread

Top Bottom