Examples

• Jul 11, 2025
• 3 minutes to read

This section lists examples for Pivot Grid, grouped by features.

Provide Data

Optimized Mode

• Bind a Pivot Grid to an MDB Database

OLAP Mode

• Connect the Pivot Grid to an OLAP Data Source at Runtime
• Bind to an OLAP Cube with the ADOMD.NET Data Provider
• Bind to an OLAP Cube with the XMLA Data Provider

Server Mode

• Server Mode with Entity Framework
• Server Mode with LINQ to SQL

Summarization

• Create a Custom Summary to Display a Distinct Value Count
• Use the Other Cell’s Values in the Current Cell Value Calculation
• Calculate and Display Custom Summaries When Pivot Grid Operates in Different Data Processing Modes
• Aggregate Data by the Field’s First Value
• Implement Custom Summary Values for Total, Grand Total, and Data Cells

Sorting

• Implement Sorting by Summary in OLAP Mode

Grouping

• How to: Implement Custom Group Intervals

Filtering

• Apply Summary Filter

Editing

• Assign In-Place Editors to Different Types of Cells
• Override the In-Place Cell Editor
• Edit Pivot Grid Cells in the UI and Store Cell Values in the Underlying Data Source

Formatting

• How to Use the Other Cell’s Values in the Current Cell Value Calculation
• Hide Row Totals
• Show Custom Display Text in Row Total Cells

Drill-Down (Underlying Data)

• Create the Underlying Data Source (Drill-Down) Asynchronously
• Edit Pivot Grid Cells in the UI and Store Cell Values in the Underlying Data Source

Layout Features

Customization Form

• Group Fields into Folders in the Customization Form
• Display the Customization Form near the Pivot Grid

Runtime Customization

• Split Field Value Cells
• Hide Specific Rows and Columns
• Hide Empty Field Values (Columns/Rows)

Save and Restore Layout

• Save and Restore the Pivot Grid Layout
• Manage Pivot Grid Layout on Restore

Export

• Customize Pivot Grid Data before Displaying it in the Chart Control
• Customize Cells in the Exported Excel Document
• Create a Custom Exporter for PivotGridControl with the XtraReport Suite

Appearance

Data Analysis

• Apply Format Rules to the Data Cells
• Display KPI Graphics

Appearance Customization

• Customize Appearance of the Even/Odd Groups of Cells

Custom Drawing

• Customize Cells
• Highlight Pivot Grid Cells that Correspond to a Series Point on Hover
• Hide Unnecessary Grid Lines and Text
• Draw a Custom Element When a User Hovers Over a Field Value with a Mouse
• Change the Field Value Header Background

Integration with the Chart Control

• Visualize Pivot Grid Data in the Chart Control
• Hide Unnecessary Series from the Chart
• Customize Pivot Grid Data before Displaying it in the Chart Control
• Print a Document that Contains Pivot Grid and Chart Controls
• Implement Custom Drawing for the Chart Control that is Bound to the Pivot Grid Control