Group summary fields

Group summary fields are used to provide summary information of various types for the groups in a report. You can summarize any or all of the groups individually by inserting a Group Summary Field into the relevant Group Footers or Headers. In addition, you can obtain a total summary for all of the groups combined, by inserting a Group Summary Field into the Report Footer or Header. To insert a Group Summary Field into a report, follow these steps:

  1. Make sure you are in Report View.

  2. Click in either a Group Header or Footer section (for individual group summaries), or in the Report Footer or Header section (for total report summaries).

  3. Select Group Summary Field from the Insert menu.

  4. The mouse pointer will turn to a cross when you move it over the report. Use your mouse to position the cross at the point in the section where you want the Group Summary Field to appear (you can move this again later, if you want) and click once.

  5. The "Insert Field Wizard" dialog is displayed, turned to the Group Summary page:

  1. In the Database Field box, the current database is displayed in Database Name and the table upon which the report is based is displayed in Data Source. These are fixed and can’t be changed by you. Click on the arrow in Data Field and choose, from the drop-down list of all the fields in your table, the field for which you want a summary. Note that a label is created for this field in the Field/Label Name box, which you can edit if you like.

  2. In the Formula box, click on the arrow to display the list of available summary options for the chosen field. These are:

  1. Click on the Next button to go to the next page. Here you can set various formats for the label that accompanies the inserted field (see Editing field labels).

  2. Click on Finish to close the dialog and return to Report View.

The Group Summary Field is inserted into the section.

If you want to insert another field just repeat the above steps.

To see what the report will look like, click on the Print Preview button on the toolbar.

Note that a Group Summary Field inserted into a group header or footer provides summary information for each of the groups, and one inserted into a report header or footer displays total summary information for all the groups combined.