TcxPivotGridCrossCell Class
An object which corresponds to a cross cell.
#Declaration
TcxPivotGridCrossCell = class(
TObject
)
#Remarks
A cross cell is associated with a subset of records in the control’s underlying data source that are used to calculate summary values for data fields and the fields whose summary values determine the sort order for “sorted by summary“ fields. This subset of records (also called “drilldown data records”) is determined using the filtering settings as specified by filter fields and grouping items (grouping columns and grouping rows that correspond to particular grouping values).
Each data cell displays a summary calculated using the subset of records provided by the corresponding cross cell object. All records from this subset have matching values in a column field(s) and row field(s) and these values are identified by column and row headers. Grand totals summary values for the fields used by the “sorting by summary” feature are calculated using the same subset of records.
A cross cell can be found at the intersection of a grouping row and grouping column. The object which corresponds to a cross cell can be accessed by passing the corresponding grouping column or row as the parameter to the GetCellByCrossItem method of the grouping row or column, respectively.
In the ExpressPivotGrid, a TcxPivotGridCrossCell
class instance represents a cross cell. To access the records associated with a cross cell, use the Records property which stores a collection of the corresponding record indexes. Use the SummaryCells property to access the summary values calculated for a particular field. To determine the grouping items for a cross cell, use the Column and Row properties, respectively.
Note
Each data cell corresponds to a cross cell
whose Create
Calling the CreateDrillDownDataSource method you can create a custom data source to display the drilldown data associated with a cross cell using our advanced ExpressQuantumGrid control which is a separate product or any other control designed for displaying table data. To access the drilldown data, use the GetRecordCount and GetValue methods of the data source object.