Export (0) Print
Expand All
Expand Minimize

Map Group Properties Dialog Box, General

SQL Server 2008 R2

Use the Group Properties dialog box to change the group expression for a layer. The group expression specifies how analytical data that has a relationship to spatial data is aggregated for each map element on the layer. By default, the group expression is the set of match fields that was specified for the relationship between the spatial data and the analytical data.

For example, for a bubble map that displays city locations and population size for a country or region, the match fields include city name [City] and region name [Region] because there can be multiple cities with the same name. The corresponding group expression includes two fields: [City] and [Region].

Name

Type a name for the item. The name must be unique in the report.

Add

Add a field to the group expression. The list of fields are combined with the AND operator. For example, [Region] AND [City].

Delete

Delete the selected field.

Group on

Select the field or expression on which to group the data. Click the Expression (fx) button to edit the expression. For a polygon layer, this value is the field in the analytical dataset that is used to match the map element on the layer.

And on

Type the next field or expression on which to group the data. Click the Expression (fx) button to edit the expression.

Community Additions

ADD
Show:
© 2014 Microsoft