Examples
- 3 minutes to read
This section provides a list of examples, grouped by features, contained in this help.
Providing Data
- How to: Bind a PivotGridControl to a Database
- 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
Data-Related Features
- How to: Implement Custom Summary
- How To: Display Custom Summary in Totals
- How to: Display Underlying Records
- How to: Add Custom Totals
- How to: Calculate Multiple Custom Totals with Custom Summary Type
- How to: Group Date-Time Values
- How to: Implement Custom Group Intervals
- 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
- 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
- How to: Locate a Column (Row) Header By Its Column’s (Row’s) Summary Values
- How to: Format Cells to Show Custom Display Text
Data 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
Layout Features
- How to: Group Fields
- How to: Create User Folders within the Customization Form
- How to: Split Field Value Cells
- How to: Hide Individual Rows and Columns
Data Formatting
Data Output
- How to: Visualize Pivot Grid Data via the XtraCharts Suite
- How to: Customize PivotGridControl Data before Displaying It in a Chart Control
- How to: Export Data
- How to: Customize a Cell in the Exported Excel Document
- How to: Print a PivotGrid and Show its Print Preview
- 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