Subreports being split over pages

[naigy via AccessMonster.com]

Hi I have a report which has 5 seperate subreports (Currently in detail
section however could be moved if required) for showing an employees
productivity in the various tasks they perform. This report normally goes
over at least 2 pages but quite often the subreports get split in half which
makes it a little hard to follow at times. Is there a way of getting each
seperate subreport to either fit on the remainder of the current page and if
not enough space to be placed on the next page and so on. Many Thanks.

 

[Marshall Barton]

Hi I have a report which has 5 seperate subreports (Currently in detail
section however could be moved if required) for showing an employees
productivity in the various tasks they perform. This report normally goes
over at least 2 pages but quite often the subreports get split in half which
makes it a little hard to follow at times. Is there a way of getting each
seperate subreport to either fit on the remainder of the current page and if
not enough space to be placed on the next page and so on.

Only sections (and groups) have the KeepTogether property.
To do what you want you need to put each subreport in its
own section.

This is fairly easy to do by creating two or three groups
(with header and footer) on the detail record's primary key
field (or any unique field that you want to sort by). You
can then spread the subreport and other detail control's
across all the sections and set the section's KeepTogether
property as needed.