Row Field
- 2 minutes to read
Row fields represent the fields which are located in the pivot grid’s row header area. The pivot grid control that has more than one row field will have the innermost row field (‘Car Name’, in the image below). Any other row fields are outer row fields. Values of the outermost row field (‘Payment Type’, in the image below) are displayed only once while values of the rest of the row 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 row field’s appearance and behavior.
Binding Settings | The Data |
Visibility | The Visible property. The pivot grid’s Options |
Position | The Area and Area For row 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 |