Bind to a Data Source
The ExpressPivotGrid loads its data using a data controller. A data controller connects the control to a data store and also performs operations on data, such as filtering and summary calculations.
The following data loading modes are provided by a data controller: OLAP, Bound, Provider and Unbound. In OLAP, bound and provider modes, a data controller is connected to a data store (via a TDataSource object or using a user-defined or custom data source). In unbound mode, you need to manually populate a data controller with data.
To display data in the ExpressPivotGrid, you need to create pivot grid fields that will represent specific data fields of a data source. You can also create unbound fields in bound or provider modes and supply custom data for displaying in the control and using in calculations.
Since the ExpressPivotGrid‘s data controller caches the data from the data source, you need to update the control manually only when its data is modified either via a field’s Values property or the pivot grid’s DataController.Values property.
Concepts
Member Table
Member Table: Bind to a Data Source