Examples
- 2 minutes to read
This section provides a list of examples, grouped by features, contained in this help.
#Provide Data
#Optimized Mode
#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
#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
#Sorting
#Grouping
#Filtering
#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
#Save and Restore Layout
#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
#Appearance Customization
#Custom Drawing
- Customize Cells
- 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