SQLConfiguration SQLConfiguration


Designing Reports   «Prev  Next»
Lesson 12 Adding page breaks to a report
Objective Add page breaks to a report.

Adding Page Breaks to a Report


Consider carefully where in the design to put the page break. If you put a page break in the Detail section you will end up with a page for every record. That is not usually what you want! It usually makes sense to put a page break at the end of one of the Footer sections. Probably one of the field footer sections (such as Company Footer or Project Description Footer). This way your report will start a new page after every grouping of data.
Visit the module wrap-up to review the terms and concepts covered in this module.


Adding page breaks

Access enables you to force page breaks based on groups. You can also insert forced breaks within sections, except in Page Header and Page Footer sections. In some report designs, it isbest to have each new group begin on a different page. You can achieve this effect easily by using the Force New Page property of a group section, which enables you to force a page break every time the group value changes.
The four Force New Page property settings are:
  1. None: No forced page break (the default)
  2. Before Section: Starts printing the current section at the top of a new page every time there is a new group
  3. After Section: Starts printing the next section at the top of a new page every time there is a new group
  4. Before & After: Combines the effects of Before Section and After Section

To force a page break before the Category group:
  1. Click anywhere in the Category header, or click the Category Header bar above the section.
  2. Display the Property Sheet and select Before Section in the Force New Page property's drop-down list.

Adding Page Breaks - Exercise

Add page breaks to the Hours by Project report in the following exercise.
Adding Page Breaks - Exercise