Column Field

• Apr 02, 2024
• 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.;

• field values.

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

Binding Settings	The DataBinding property.
Visibility	The Visible property. The pivot grid’s OptionsView.ColumnFields property.
Position	The Area and AreaIndex properties. For column fields, the Area property is set to faColumn.
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.ColumnTotals and OptionsView.TotalsForSingleValues properties.
Grand Totals	The pivot grid’s OptionsView.ColumnGrandTotals 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.