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 CreateDrillDownDataSource method can be used to get a subset of records in the control’s underlying data source that are associated with the cross cell. A cross cell can be accessed via the pivot grid’s HitTest property. When the test point (accessible via the HitTest.HitPoint property) belongs to a data cell (in this instance, the HitTest.HitAtDataCell property returns True), you can cast the HitTest.HitObject property to the TcxPivotGridDataCellViewInfo class. This class provides the CrossCell property to access the cross cell which corresponds to the data cell. When handling various events such as OnClick and OnDblClick, the HitTest property is automatically initialized with the information on the point under the mouse pointer.
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.