Row Field

• Sep 06, 2024
• 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.;

• field values.

The table below lists the main properties which affect a row field’s appearance and behavior.

Binding Settings	The DataBinding property.
Visibility	The Visible property. The pivot grid’s OptionsView.RowFields property.
Position	The Area and AreaIndex properties. For row fields, the Area property is set to faRow.
Appearance	For all field headers, the pivot grid’s Styles.FieldHeader property. To dynamically customize these style settings, handle the pivot grid’s Styles.OnGetFieldHeaderStyle event. 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 OnCustomDrawFieldHeader event.
Grouping Field Values	The GroupInterval and GroupIntervalRange properties.
Linking with Other Fields	The Group property.
Sort Order	The SortOrder and SortBySummaryInfo properties.
Filter Criteria	The Filter property.
Subtotals	The TotalsVisibility, CustomTotals properties. The pivot grid’s OptionsView.RowTotals and OptionsView.TotalsForSingleValues properties.
Grand Totals	The pivot grid’s OptionsView.RowGrandTotals and OptionsView.GrandTotalsForSingleValues properties.
Context Menu	Refer to the Field Header Context Menu topic.
Hints	The pivot grid’s OptionsBehavior.FieldHeaderHints property. The pivot grid’s OnGetCellHint event.
HitTest Information	The HitTest.HitAtField and HitTest.HitAtGroupHeader properties.