Collapse All Expand All

To group a report on a field

1. Right-click the design surface of a report and select Insert, then Group Header/Footer to add a group header and group footer section.
2. With the group header selected in the Properties window, drop down the DataField property and select the field on which to group the report.

To group a report on a field expression

1. Right-click the design surface of a report and select Insert, then Group Header/Footer to add a group header and group footer section.
2. Enter a field expression in the DataField property, for example, =City + Country (For more information on field expressions, see the Add Field Expressions topic.)