Keeping data together across pages in a report

[pruckelshaus]

I have an Access 2007 report. It displays counts of students by graduation
year, and is grouped by teacher...something like this:

Teacher name
2010 3
2011 4
2012 3
2013 3
Total: 13

There are 85 teachers, so the report spans a dozen or so pages. Now, even
though I have "Keep together" selected in the property sheet of each section
of my report, there are page breaks in the middle of each section. How do I
absolutely, positively force everything between "teacher name" and "total" to
stay together on teh same page without forcing a page break after each
teacher's section?

Thanks

Pete

 

[Allen Browne]

In report design view, open the Sorting And Grouping pane, and select the
group based on the Teacher field.

You will see an option in the Sorting'n'Grouping pane (not in the Properties
box), for:
Keep whole group together on one page.

 

[pruckelshaus]

Brilliant, thanks!