Keep the data in a group together on a page or in a column in a report

1. Open the report in Design view.
   
   
2. Click Sorting And Grouping on the toolbar to display the Sorting And Grouping box.
   
   
3. Set the group levels for the report.

   How?

4. Click the field or expression for the group level that you want to keep together.
   
   
5. In the group properties section of the Sorting And Grouping box, set the KeepTogether property to one of the following settings:
   • Whole Group. The group header, all detail records, and the group footer are printed on the same page or in the same column.
     
     
   • With First Detail. The group header is printed on a page or in a column only if it can also print the first detail record.
6. Display the property sheet for the report.

   How?

7. Set the GrpKeepTogether property to one of the following settings:
   • Per Page. Keeps the group together on the page.
     
     
   • Per Column/Row. Keeps the group together in the column or row.

Notes

• If you want to keep the data in one section together, for example, a record in the detail section, set the KeepTogether property for that section to Yes.

  How?

• The Alphabetical List of Products report in the Northwind sample database keeps the products for each letter together as a group. To view this report, open the Northwind database in the Samples subfolder of your Office folder, and then open the Alphabetical List of Products report in Design view. For information on opening Northwind, click .