Groups and page breaks 2

[dh42891]

Is there any way to force everything related to a group to stay on the same page? I have ticket sales grouped by date with details showing each client who has a reservation for that day, and then totals for various fields. But, depending on how many records are returned (which will change daily) sometimes the group totals or some records are seperated from the rest of the group. I want to force a page break whenever a group is going to pass through to the next page. Any suggestions, if that made sense...?

thanks,

dylan
CR 8.5
ODBC

 

[lbass]

You might try going to report->change group expert->options-> and checking "Keep group together". This might be all you need to do. Otherwise, you can force page breaks after a certain number of records per page, by going to the section expert->details->new page after->x+2 and entering:

remainder({#cntwingrp},25) = 0 //substitute your number for 25

...where {#cntwingrp} is a running total (using the running total expert) which selects any recurring field, count, evaluate for each record, reset on change of group. You would also want to format the group footer by adding:

Not OnLastRecord

to the "New Page After" x+2 formula area. This will create a page break after each group so that the running total starts at the top of the first page for each group. This may or may not make sense for your purposes.

-LB

 

[dh42891]

Thanks a bunch lbass, the keep group together option was exactly what I needed. Appreciate it,

dylan

 

[bmcdougall]

I am trying to create a page break by day, after a new day start a new page. Please help!!

 

[lbass]

Insert a group on your date field and then go to the section expert (format->ection)->Group (Date) Footer->New Page After->x+2 and enter:

Not onlastrecord

This will give you a new page after each day except on the last day. In the section expert, you can also suppress the group header and group footer if you don't want them to display.

-LB