Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Collapse]Fundamentals
     Product Class Structure
     Information Presentation Basics
     Hierarchical Value Presentation
     Fields
     Deployment
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Data Formatting
   [Expand]Layout
   [Expand]Appearance
   [Expand]Data Export
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]Examples
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[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 Fields represent data source fields and supply specific data to ASPxPivotGrid. Fields are visually represented by field headers that can be moved between control areas using drag-and-drop. Dragging fields between the areas modifies the layout of the report.

To create a report in ASPxPivotGrid, create pivot grid fields and position them 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 drop-down.

Expanded Binding Basics

ASPxPivotGrid supports bound and unbound fields. A bound field retrieves data from a field in a pivot grid'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 Data.

To bind a pivot grid field to a data source field, use the PivotGridField.FieldName property. This property provides the name of the data field bound to a pivot grid 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

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