corelibraries-devexpress-dot-xtrapivotgrid-dot-pivotgridoptionsdatafield.md
Gets or sets the area in which the data field headers are displayed.
Namespace : DevExpress.XtraPivotGrid
Assembly : DevExpress.PivotGrid.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
[DefaultValue(PivotDataArea.None)]
public PivotDataArea Area { get; set; }
<DefaultValue(PivotDataArea.None)>
Public Property Area As PivotDataArea
| Type | Default | Description |
|---|---|---|
| PivotDataArea | None |
A PivotDataArea value that specifies the area in which the data field headers are displayed.
|
Available values:
| Name | Description |
|---|---|
| None |
The data field headers are displayed as column headers. The data header is hidden.
| | ColumnArea |
The data field headers are displayed as column headers. The data header is displayed within the column header area.
| | RowArea |
The data field headers are displayed as row headers. The data header is displayed within the row header area.
|
You can access this nested property as listed below:
| Library | Object Type | Path to Area |
|---|---|---|
| WinForms Controls | PivotGridControl |
.OptionsDataField .Area
| | .NET Reporting Tools | XRPivotGrid |
.OptionsDataField .Area
|
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:
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.
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:
The following code snippets (auto-collected from DevExpress Examples) contain references to the Area property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.
winforms-pivot-grid-hide-specific-columns-and-rows/CS/Data.cs#L34
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea;
pivot.OptionsDataField.AreaIndex = 1;
winforms-pivot-split-field-value-cells/CS/Data.cs#L32
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea;
pivot.OptionsDataField.AreaIndex = 1;
winforms-pivot-grid-hide-empty-columns-and-rows/CS/Data.cs#L33
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea;
pivot.OptionsDataField.AreaIndex = 1;
web-forms-pivot-grid-split-field-value-cells/CS/ASPxPivotGrid_SplittingCells/Data.cs#L33
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea;
pivot.OptionsDataField.AreaIndex = 1;
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far;
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea;
pivot.OptionsDataField.AreaIndex = 1;
winforms-pivot-grid-hide-specific-columns-and-rows/VB/Data.vb#L38
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea
pivot.OptionsDataField.AreaIndex = 1
winforms-pivot-split-field-value-cells/VB/Data.vb#L36
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea
pivot.OptionsDataField.AreaIndex = 1
winforms-pivot-grid-hide-empty-columns-and-rows/VB/Data.vb#L45
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea
pivot.OptionsDataField.AreaIndex = 1
web-forms-pivot-grid-split-field-value-cells/VB/ASPxPivotGrid_SplittingCells/Data.vb#L46
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea
pivot.OptionsDataField.AreaIndex = 1
pivot.OptionsView.ColumnTotalsLocation = PivotTotalsLocation.Far
pivot.OptionsDataField.Area = PivotDataArea.ColumnArea
pivot.OptionsDataField.AreaIndex = 1
See Also
PivotGridOptionsDataField Class