Examples
- 3 minutes to read
This section provides a list of how-to examples contained in this help, grouped by features (Binding to Data, Grouping, Filtering and Summarizing, Appearance Customization and Miscellaneous).
Binding to Data
- How to: Bind a PivotGrid to an MS Access Database
- How to: Bind a PivotGrid to an MS Access Database Programmatically
- How to: Bind a PivotGrid to an OLAP Cube Using the OLE DB Data Provider
- How to: Bind a PivotGrid to an OLAP Cube Using the ADOMD.NET Data Provider
- How to: Bind a PivotGrid to an OLAP Cube via XMLA
- How to: Display Unbound Data in a PivotGrid Control
- How to: Work with a PivotGrid Control Offline
- How to: Format Cell Values
- How to: Obtain Underlying Data (Drill-Down)
- How to: Bind the Pivot Grid to Fields and Groups specified in ViewModel
Grouping, Filtering and Summarizing
- How to: Group Fields
- How to: Group Date-Time Values
- How to: Implement Custom Group Intervals
- How to: Apply a Filter to a Field
- How to: Implement the Group Filter
- How to: Display Top N Values
- How to: Add Custom Totals
- How to: Calculate Multiple Custom Totals with Custom Summary Type
- How to: Create a Custom Summary to Display the Distinct Value Count
- How to: Sort Data by Grand Totals
- How to: Sort Data by Individual Columns (Rows)
- How to: Sort Data by Individual Columns (Rows) in OLAP Mode
- How to: Sort Data in Server Mode Using the Custom Sorting Algorithm
- How to: Prevent End-Users From Changing Filter Conditions
- How to: Add and Remove Items From Filter Drop-Down Lists
- How to: Sort Filter Drop-Down Items in a Custom Manner
- How to: Calculate Cumulative Values in the Pivot Grid Control
- How to: Format Cells to Show Custom Display Text
- How to Implement a Context Menu Action to Display Top 5 Values in a Column or Row
Appearance Customization
- How to: Customize Pivot Grid Colors
- How to: Customize the Cell Template
- How to: Create the Field Value Template
- How to: Apply Conditional Formatting to Data Cells
- How to: Specify Custom Styles for Pivot Grid Elements
- How to: Select Cell Templates Based on Custom Logic
- How to: Customize the Appearance of Cells
- How to: Override Theme Colors
Menu
Miscellaneous
- How to: Visualize Data from a Pivot Grid Control using the Chart Control
- How to: Customize a PivotGrid Control’s Data before Displaying It in a Chart Control
- How to: Save and Restore Layout to/from XML
- How to: Save and Restore Layout to/from a Stream
- How to: Localize a Pivot Grid via the PivotGrid Localizer
- How to: Copy Data from a PivotGrid Control into the Clipboard
- How to: Split Field Value Cells
- How to: Hide Individual Rows and Columns
- How to: Locate a Column (Row) Header By Its Column’s (Row’s) Summary Values