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
   [Collapse]Fundamentals
     Fields
     Information Presentation Basics
     Hierarchical Value Presentation
     Product Class Structure
     Main Features
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]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

Fields

Pivot Grid Control Fields represent data source fields and supply specific data to PivotGridControl. Fields are visually represented by field headers that can be moved between a control's areas using drag-and-drop. Dragging fields between the areas modifies the layout of the report.

To create a report in PivotGridControl, Pivot Grid Control fields should be created and positioned within appropriate areas.

A field can be positioned within one of four areas: Column, Row, Data, and Filter Header Area. The field's function is determined by the area in which it is displayed:

  • position a field within the Column Header Area to list its values along the control's top edge. This field's values will represent column headers;
  • position a field within Row Header Area to list its values along the control's left edge. This field's values will represent row headers;
  • position a field within Data Header Area to calculate summaries against this fields. The summaries will be calculated for all the cells, each cell is identified by a specific column and row;
  • position a field within the Filter Header Area to make this field available for further customizations. For instance, it can be dragged to a different area later. In addition, an end-user can filter data against a filter field via the Filter Dropdown.

Expanded Binding Basics

Pivot Grid Control supports bound and unbound fields. A bound field retrieves data from a field in a Pivot Grid Control's data source. An unbound field is not associated with a data source and should be populated with data manually. To learn more on unbound fields, see Unbound Fields.

To bind a Pivot Grid Control field to a data source field, use the PivotGridFieldBase.FieldName property. This property provides the name of the data field bound to the Pivot Grid Control field. The PivotGridFieldBase.UnboundType property must be set to UnboundColumnType.Bound.

To learn more, see Binding to Data Overview and Binding to OLAP Data Sources.

Expanded Example

Expanded See Also

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