Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Collapse]Layout
     Field Location and Order
     Data Cell Layout
     Field Groups
    [Expand]Customization Form
     Best Fit
     Save and Restore Layout
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Appearance
   [Expand]Design-time Features
   [Expand]Miscellaneous
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Examples
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Data Cell Layout

The data header allows you to customize the location and orientation of data field headers and therefore, the location of data cells as well.

Expanded Data Header Overview

By default, when there are two or more data fields, data field headers are displayed to distinguish between different summary values; data cells are located one after another as shown in the image below.

The data header allows you to control the location and orientation of data field headers and therefore, the location of data cells. This header is linked with data field headers. The image below shows the data header located within the Row Header Area.

Expanded Customizing the Data Header

Like any other field header, end-users can customize the layout of data field headers by changing the location of the data header using drag and drop.

For example, end-users can locate the data field headers along the left inner edge...

...or the top outer edge of the PivotGridControl.

Expanded Customizing the Data Header in Code

The PivotGridControl.OptionsDataField property provides options that control the content, size and availability of the data header. These options are listed and described briefly in the table below.

Property Description
PivotGridOptionsDataField.Area

Determines the area in which the data field headers are displayed when there are two or more data fields.

Setting this property to PivotDataArea.ColumnArea or PivotDataArea.RowArea enables the Data Header. 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 the associated location.

PivotGridOptionsDataField.AreaIndex Specifies the position of the data field headers within the hierarchy of field values.
PivotGridOptionsDataField.Caption Specifies the text displayed within the Data Header.
PivotGridOptionsDataField.RowHeaderWidth Specifies the width of the data field headers when they are displayed as row headers.
PivotGridOptionsDataField.RowValueLineCount Specifies the height of data field headers in text lines. This property is in effect when there are two or more data fields, and data field headers are displayed in the Row Header Area.
PivotGridOptionsDataField.ColumnValueLineCount Specifies the height of data field headers, in text lines. This property is in effect when there are two or more data fields, and data field headers are displayed in the Column Header Area.

How would you rate this topic?​​​​​​​