Column Field
- 2 minutes to read
Column fields represent the fields which are located in the pivot grid’s column header area. The pivot grid control that has more than one column field will have the innermost column field (‘Month’, in the image below). Any other column fields are outer column fields. Values of the outermost column field (‘Payment Type’, in the image below) are displayed only once while values of the rest of the column fields can be repeated.
A field consists of the following elements:
a field header which displays the field’s caption and enables end-users to sort and filter field values, change the field’s location via drag-and-drop, etc.;
The table below lists the main properties which affect a column field’s appearance and behavior.
Binding Settings | The Data |
Visibility | The Visible property. The pivot grid’s Options |
Position | The Area and Area For column fields, the Area property is set to fa |
Appearance | For all field headers, the pivot grid’s Styles. To dynamically customize these style settings, handle the pivot grid’s Styles. Note These style settings do not modify an element’s background if the pivot grid is painted using the Windows XP (native) or Office2003 style. |
Custom Draw Event | The On |
Grouping Field Values | The Group |
Linking with Other Fields | The Group property. |
Sort Order | The Sort |
Filter Criteria | The Filter property. |
Subtotals | The Totals The pivot grid’s Options |
Grand Totals | The pivot grid’s Options |
Context Menu | Refer to the Field Header Context Menu topic. |
Hints | The pivot grid’s Options The pivot grid’s On |
Hit | The Hit |