20
Contents
© 2018 Developer Express Inc.
20
.............................................................................................................................................................. 3668How to: Bind a PivotGridControl to an OLAP Cube Using the OLE DB Data Provider
.............................................................................................................................................................. 3671How to: Bind a PivotGridControl to an OLAP Cube Using the ADOMD.NET Data Provider
.............................................................................................................................................................. 3673How to: Bind a PivotGridControl to an OLAP Cube via XMLA
.............................................................................................................................................................. 3675How to: Add an Unbound Field to Supply Additional Data
.............................................................................................................................................................. 3677How to: Add an Unbound Field to Change Axis Detailing
.............................................................................................................................................................. 3679How to: Provide Data for an Unbound Field Using Expressions
.............................................................................................................................................................. 3680How to: Save PivotGridControl Data to a File and Work with It Later
.............................................................................................................................................................. 3681How to: Bind a PivotGridControl to a Database at Design Time Using Server Mode
........................................................................................................................................................................... 3688Data-Related Features
.............................................................................................................................................................. 3689How to: Implement Custom Summary
.............................................................................................................................................................. 3691How To: Display Custom Summary in Totals
.............................................................................................................................................................. 3696How to: Display Underlying Records
.............................................................................................................................................................. 3698How to: Add Custom Totals
.............................................................................................................................................................. 3700How to: Calculate Multiple Custom Totals with Custom Summary Type
.............................................................................................................................................................. 3707How to: Group Date-Time Values
.............................................................................................................................................................. 3708How to: Implement Custom Group Intervals
.............................................................................................................................................................. 3710How to: Sort Data by a Data Field
.............................................................................................................................................................. 3711How to: Sort Data by Columns (Rows) in Code
.............................................................................................................................................................. 3713How to: Sort Data by Columns (Rows) in OLAP Mode
.............................................................................................................................................................. 3715How to: Sort Data in Server Mode Using Custom Sorting Algorithm
.............................................................................................................................................................. 3718How to: Sort the Pivot Grid's Data by OLAP Member Properties
.............................................................................................................................................................. 3720How to: Apply Filter to a Field
.............................................................................................................................................................. 3721How to: Apply Summary Filter
.............................................................................................................................................................. 3723How to: Prevent End-Users From Changing Filter Conditions
.............................................................................................................................................................. 3725How to: Add and Remove Items From Filter Drop-Down Lists
.............................................................................................................................................................. 3727How to: Implement Group Filter for a PivotGrid
.............................................................................................................................................................. 3729How to: Change the Prefilter Criteria in Code
.............................................................................................................................................................. 3730How to: Use Asynchronous Operations That Return the Result
.............................................................................................................................................................. 3732How to: Sort Filter Drop-Down Items in a Custom Manner
.............................................................................................................................................................. 3734How to: Locate a Column (Row) Header By Its Column's (Row's) Summary Values
.............................................................................................................................................................. 3738How to: Format Cells to Show Custom Display Text
........................................................................................................................................................................... 3740Data Editing
.............................................................................................................................................................. 3741How to: Assign an In-place Editor to a Data Field's Cells
.............................................................................................................................................................. 3742How to: Assign In-place Editors to Particular Cells
.............................................................................................................................................................. 3747How to: Override the Default Cell Editor for the In-Place Editing
.............................................................................................................................................................. 3750How to: Prevent Editors from Being Opened for Individual Cells
........................................................................................................................................................................... 3751Layout Features
.............................................................................................................................................................. 3752How to: Group Fields
.............................................................................................................................................................. 3753How to: Create User Folders within the Customization Form
.............................................................................................................................................................. 3755How to: Split Field Value Cells
.............................................................................................................................................................. 3764How to: Display the Customization Form near the PivotGridControl
.............................................................................................................................................................. 3766How to: Hide Individual Rows and Columns
........................................................................................................................................................................... 3775Data Formatting
.............................................................................................................................................................. 3776How to: Format Cell Values
........................................................................................................................................................................... 3777Data Output
.............................................................................................................................................................. 3778How to: Visualize Pivot Grid Data via the XtraCharts Suite
.............................................................................................................................................................. 3779How to: Customize PivotGridControl Data before Displaying It in a Chart Control
.............................................................................................................................................................. 3781How to: Export Data
.............................................................................................................................................................. 3782How to: Customize a Cell in the Exported Excel Document
.............................................................................................................................................................. 3785How to: Print a PivotGrid and Show its Print Preview
.............................................................................................................................................................. 3787How to: Copy Data to the Clipboard
........................................................................................................................................................................... 3789Appearance
.............................................................................................................................................................. 3790How to: Customize Appearances of Cells via an Event
.............................................................................................................................................................. 3791How to: Apply Conditional Formatting to Data Cells
.............................................................................................................................................................. 3794How to: Custom Paint Cells
.............................................................................................................................................................. 3797How to: Change the Field Value Header Appearance
........................................................................................................................................................................... 3798Miscellaneous
.............................................................................................................................................................. 3799How to: Save and Restore Layout