Examples
- 3 minutes to read
This section provides a list of examples, grouped by features, contained in this help.
Providing Data
- How to: Create the Fields and Bind the PivotGridControl to a Data Source
- How to: Bind a PivotGridControl to an OLAP Cube Using the OLE DB Data Provider
- How to: Bind a PivotGridControl to an OLAP Cube Using the ADOMD.NET Data Provider
- How to: Bind a PivotGridControl to an OLAP Cube via XMLA
- How to: Add an Unbound Field to Supply Additional Data
- How to: Add an Unbound Field to Change Axis Detailing
- How to: Provide Data for an Unbound Field Using Expressions
- How to: Save PivotGridControl Data to a File and Work with It Later
- How to: Bind a PivotGridControl to a Database at Design Time Using Server Mode
- Server Mode with Entity Framework
- Server Mode with LINQ to SQL
Summarization
- How to: Implement Custom Summary
- How To: Display Custom Summary in Totals
- How to: Add Custom Totals
- How to: Calculate Multiple Custom Totals with Custom Summary Type
- How to: Locate a Column (Row) Header By Its Column’s (Row’s) Summary Values
Sorting
- How to: Sort Data by a Data Field
- How to: Sort Data by Columns (Rows) in Code
- How to: Sort Data by Columns (Rows) in OLAP Mode
- How to: Sort Data in Server Mode Using Custom Sorting Algorithm
- How to: Sort the Pivot Grid’s Data by OLAP Member Properties
Grouping
Filtering
- How to: Apply Filter to a Field
- How to: Apply Summary Filter
- How to: Prevent End-Users From Changing Filter Conditions
- How to: Add and Remove Items From Filter Drop-Down Lists
- How to: Implement Group Filter for a PivotGrid
- How to: Change the Prefilter Criteria in Code
- How to: Sort Filter Drop-Down Items in a Custom Manner
Editing
- How to: Assign an In-place Editor to a Data Field’s Cells
- How to: Assign In-place Editors to Particular Cells
- How to: Override the Default Cell Editor for the In-Place Editing
- How to: Prevent Editors from Being Opened for Individual Cells
- How to Edit and Save Cell Values
Formatting
Drill-Down (Underlying Data)
- How to: Display Underlying Records
- How to: Create the Underlying Data Source (Drill-Down) in an Asynchronous Operation
Layout Features
- How to: Create User Folders within the Customization Form
- How to: Split Field Value Cells
- How to: Hide Individual Rows and Columns
- How to: Save and Restore Layout
- How to: Save and Load Field Values’ Collapsed States Together With Pivot Grid Layout
- How to: Display the Customization Form near the PivotGridControl
Export
- How to: Export Data
- How to: Visualize Pivot Grid Data via the XtraCharts Suite
- How to: Customize PivotGridControl Data before Displaying It in a Chart Control
- How to: Customize a Cell in the Exported Excel Document
- How to: Print a PivotGrid and Show its Print Preview
- How to: Copy Data to the Clipboard
Appearance
- How to: Customize Appearances of Cells via an Event
- How to: Apply Conditional Formatting to Data Cells
- How to: Custom Paint Cells
- How to: Change the Field Value Header Appearance
- How to: Format Cells to Show Custom Display Text
- How to: Customize the Grand Total Text using the FieldValueDisplayText event
- How to: Display KPI Graphics in Cells