Report, Sorting And Grouping Box.
You can use the GroupHeader and GroupFooter properties to create a group header or a group footer for a selected field or expression. You can use group headers and footers to label groups or summarize data in a group. For example, you can have a Beverages group header that identifies the group of records for beverage products.
The GroupHeader and GroupFooter properties use the following settings.
|
Setting |
Description |
|
Yes |
Creates a group header or footer. |
|
No |
(Default) Doesn’t create a group header or footer. |
You set these properties in the Sorting And Grouping box, available by clicking Sorting And Grouping on the View Menu or by clicking the Sorting And Grouping button on the toolbar.
You can set them only in report Design view.
Note You can’t set or refer to these properties directly in Visual Basic. To create a group header or footer for a field or expression in Visual Basic, use the CreateGroupLevel function.
To set the Group properties — GroupOn, GroupInterval, and KeepTogether — to other than their default values, you must first set the GroupHeader or GroupFooter property to Yes for the selected field or expression.
CreateGroupLevel Function, GroupInterval Property, GroupLevel Property, GroupOn Property, KeepTogether Property — Groups, SortOrder Property.