disable split record on sub reports

  • Thread starter Thread starter Cristiano d.
  • Start date Start date
One way to handle this is to put the sub-report in its own section (group by
primary key in the detail) and put the sub-report in group footer.

Set the group footer's Keep Together property to Yes. The report tool will
then do its best to keep everything for the sub-report on the same page.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Saw this answer to another user's question. I have a similar issue. I have a report with 3 sub-reports - all in detail section. Would like to use Group By for each sub-report so I can control page breaks depending on number of records...but how do I use Group By function for a sub-report? When using the Group & Sort tool I'm only allowed to select bound fields...not any of the sub-reports.

Thanks!
 
Just Group by the last field you sorted or grouped by again and again and yet
again. Or Group by a constant expression

Then add a group header or footer and put your sub-reports in the individual
group section.

The sorting and grouping dialog might look like
Field/Expression
[PatientLastName] Asc
=1 Ascending
=1 Ascending
=1 Ascending

Make sure you set Group footer to Yes for each of those last 3
Also set Keep Together to yes



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