PivotGridOptionsDataField.AreaIndex Property

Gets or sets the position of the data field headers.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v20.2.Core.dll

Declaration

[DefaultValue(-1)]
public int AreaIndex { get; set; }
<DefaultValue(-1)>
Public Property AreaIndex As Integer

Property Value

Type Default Description
Int32

-1

An integer which specifies the position of the data field headers within the hierarchy of field values.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to AreaIndex
WinForms Controls PivotGridControl
.OptionsDataField.AreaIndex
ASP.NET Controls and MVC Extensions ASPxPivotGrid
.OptionsDataField.AreaIndex
MVCxPivotGrid
.OptionsDataField.AreaIndex
PivotGridSettings
.OptionsDataField.AreaIndex
Reporting XRPivotGrid
.OptionsDataField.AreaIndex

Remarks

Data field headers are displayed when the XtraPivotGrid control contains two or more data fields. By default, the AreaIndex property is set to -1, so the data field headers are displayed immediately above the Data Area when they are positioned within the column area (or immediately to the left of the Data Area when positioned within the row area):

OptionsDataField_LocationIndex-1

Setting the AreaIndex property to 0 displays data field headers above the field values of the first column field:

OptionsDataField_LocationIndex0

If the AreaIndex property is set to 1 the data field headers will be displayed under the field values of the first column field, as in the image below:

OptionsDataField_LocationIndex1

See Also