This dialog box appears when you click Insert Summary on the Standard toolbar or when you Insert, Summary from the menu bar.
Use the Insert Summary dialog box to summarize the data in a field in the report.
- You cannot sum or average a variable, text, Boolean, date/time, time, or date field.
- If you choose the In specified order option, the Specified Order tab appears.
- When you add a new Named Group, the Others Tab appears.
Summary Types: This list contains all the summary operations available for use in your report. Select the appropriate operation.
Fields (to summarize): This list displays the fields and formulas used in the report. Select the field to summarize.
Fields (to sort and group by): This list displays the fields and formulas used in the report. Select the field to sort and group by.
Sort direction: This list contains four sort direction options. The default option is in ascending order. To change the sort direction, click the box to see the options, then make your selection from the list.
Show as a percentage of: Select this check box to calculate the percentage total of one group within a broader grouping. For example, you can show the percentage of sales in each city based on the total sales for each country.
After you select the check box, you can choose the total or group you want the comparison to be based on.
Note: The percentage option is available only when the result of a summary operation is numeric.
Keep group together: Select this check box to keep groups from being split across a page. This forces groups to stay together. If there is enough room to keep them on the current page, the program prints them on the current page. If there is not enough room, the program prints them on the next page.
Repeat group header on each new page: Select this check box to print a new group header at the top of each page if a group is spread over several pages. Otherwise, a group header prints only at the beginning of the group.