Widows and orphans

It can sometimes be difficult when you are creating reports, especially large ones, to remember that grouped fields and their respective headers and footers are likely at some point to be split awkwardly over consecutive pages. Obviously you want to avoid having a stray header at the bottom of one page and the fields it heads over on the next page! Ability enables you to guarantee that a grouped field and its header/footer are kept together in your reports.

After you have created your report and selected the fields to be grouped (see Grouping and sorting in a report), do the following:

  1. Select Sections from the Format menu.

  2. Click on the Groups tab in the Section Properties box.

  3. The Group name/s are on the left, with the three group options on the right. Use the drop-down list to set Yes or No for one or more of the following options:

  1. Click on OK to apply the settings and return to report design view.

Click on the Print Preview button to see how headers, footers and groups are kept together as determined by the option you chose.