PivotGridOptionsDataField.Area Property

Gets or sets the area in which the data field headers are displayed.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

[DefaultValue(PivotDataArea.None)]
public PivotDataArea Area { get; set; }
<DefaultValue(PivotDataArea.None)>
Public Property Area As PivotDataArea

Property Value

Type Default Description
PivotDataArea

None

A PivotDataArea value that specifies the area in which the data field headers are displayed.

Property Paths

You can access this nested property as listed below:

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

Remarks

The Area property determines the area in which the data field headers are displayed when there are two or more data fields. This property also enables the data header which allows end-users to move data field headers between and within the column header area and row header area.

By default, the data field headers are displayed as column headers:

OptionsDataField_LocationIndex-1

If the Area property is set to PivotDataArea.ColumnArea the data field headers are still displayed as column headers. In addition, the data header is enabled and displayed within the column header area. The data header is a header which is linked with the data field headers. It can be dragged to a specific position within the column header area or row header area and as a result the data field headers will be moved to an appropriate location.

OptionsDataField_LocationIndex-1_DataHeader

If the Area property is set to PivotDataArea.RowArea the data header will be moved to the row header area and the data field headers will be displayed as row headers:

OptionsDataField_LocationIndex-1_DataHeader_Row

See Also