Pagination of subreports

[Steve Crawley]

My report displays a single record and has 15 subreports. Some of these sub
reports have the CAN GROW and CAN SHRINK property set to YES. So, the
position of the subreports varies from record-to-record (due to the
canshrink/grow). I am trying to avoid the case where a subreport is split
over 2 pages. Inserting 15 page breaks works but produces lots of white
space!! Is there a better way to achieve this?? Thanks in advance.

 

[John Spencer]

You could try adding groups based on the primary key of your main report. Or
if you don't have any primary key/record source just set each group's soruce
to the expression =1

Then in the header and footer section of each group set one of the sub-report
controls.

Set each group section's Keep Together property to Yes

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Marshall Barton]

My report displays a single record and has 15 subreports. Some of these sub
reports have the CAN GROW and CAN SHRINK property set to YES. So, the
position of the subreports varies from record-to-record (due to the
canshrink/grow). I am trying to avoid the case where a subreport is split
over 2 pages. Inserting 15 page breaks works but produces lots of white
space!! Is there a better way to achieve this??

To get the KeepTogether effect on a single control (e.g.
text box, subreport, etc), the control needs to be in its
own section.

This can be done by creating addition groups in Sorting and
Grouping (View menu). Set the grouping field to the same
thing that's used to sort the detail records. For 15
subreport controls, you would need 7 (or maybe 8) groups,
all set to the same field and all with group header and
footer sections. Then you can spread the subreports across
these extra sections and set each section's KeepTogether
property to Yes.

 

[Steve Crawley]

Great. That worked. Thanks for your help.