The main properties of the TPivotGridEh class

property ActualColFlds: TStringList;

Returns a list of the actual fields for the columns axis. Data is taken from PivotDataSource.ActualColFlds.

property ActualRowFlds: TStringList;

Returns a list of the actual fields for the rows axis. Data is taken from PivotDataSource.ActualRowFlds.

property ActualValueFields: TValueFieldsCollectionEh;

Returns a list of the actual value fields. The data is taken from the PivotDataSource. ActualValueFields.

property ColsAxisTree: TPivotAxisGroupingTreeEh;

Returns the value tree for the columns axis.

property DataBuildingProgressDelay: Integer default 1000;

Sets the length of the delay before displaying the progress bar. The default value is 1 second.

property DefaultColWidth: Integer default 80;

Specifies the default column value that is used when generating data.

property DefaultDateTimeSliceLevels: TDateTimeSliceLevelsEh read default [dtslYearEh, dtslMonthEh, dtslDayEh];

Specifies the level of "splitting" of fields of type Date / Time when the fields are formed using the PivotFields.RebuildPivotFields method.

property GridCellParams: TPivotGridCellParamsEh;

Sets the color and font for the data cells in the summary analysis grid.

property GridLineParams: TPivotGridLineParamsEh;

Sets the color and visibility of separating lines in the summary analysis grid.

property Options: TPivotGridOptionsEh default [pgoColSizingEh, pgoEditingEh, pgoWantTabEh, pgoFieldDraggingEh, pgoGrandTotalColumnEh, pgoGrandTotalRowEh, pgoDataSortingEh, pgoDataFiltersEh];

Sets the values that affect various aspects of grid behavior.

pgoRowSizingEh
Allow the user to change the height of the rows with the mouse.

pgoColSizingEh
Allow the user the width of the columns with the mouse.

pgoEditingEh
Allow the user to edit the data in the grid. For details on editing data, see "Editing cells in TPivotGridEh".

pgoWantTabEh
The Tab key is processed inside the grid to go to the next cell.

pgoFieldDraggingEh,
Allow the user to drag the fields in the Grid with the mouse....

pgoGrandTotalColumnEh
Display the column of total amounts.

pgoGrandTotalRowEh
Display the row for total amounts.

pgoDataSortingEh
Allow the user to sort the data by clicking on the field headers.

pgoDataFiltersEh
Allow the user to filter the data by clicking on the opening section of the drop-down form to filter the data in the field headers.

property PivotDataSource: TPivotDataSourceEh;

Specifies a component of type TPivotDataSourceEh whose values are used to generate summary data.

property PivotFields: TPivotFieldsEh;

Returns a list of available fields for generating summary data. Data is taken from PivotDataSource.PivotFields.

property RowAggrBeforeData: Boolean;

Specifies that the summary lines are displayed before the data lines.

property RowHeight: Integer;

The default height of the rows is in pixels.

property RowLines: Integer;

The height of the lines by default in the lines of text.

property RowsAxisTree: TPivotAxisGroupingTreeEh;

Returns the value tree on the row axis.

property ShowDataBuildingProgress: Boolean default True;

Defines the need to display the progress bar during data generation.

property ShowHint: Boolean stored IsShowHintStored;

Specifies whether to display the prompt from the Hint property.

property ShowToolTips: Boolean;

Specifies the need to display the text in the specialty hint box if the text does not fit in the cell.

property VisPivotGridArray[ACol, ARow: Integer]: TPivotCellEh;

Access to an array of pivot table values.

property PrintService: TCustomPivotGridPrintServiceEh;

Returns the TCustomPivotGridPrintServiceEh object used for printing and previewing.

Wraping text in Axis area

To enable text wrapping in cells, set the TPivotGridEh.RowAxisOptions.AutoWordWrap property for row axis cells or TPivotGridEh.ColumnAxisOptions.AutoWordWrap for column axis cells.

Display Total cells at the level of Child elements.

To activate the display mode of Total cells at the level of Child elements, set the TPivotGridEh.RowAxisOptions.TotalAtParentLevel property to False for row axis cells or TPivotGridEh.ColumnAxisOptions.TotalAtParentLevel to False for column axis cells.

Display Total cells before cells with data.

To activate the mode of displaying Total cells before cells with data, set the TPivotGridEh.RowAxisOptions.TotalsBeforeData property to True for row axis cells, or TPivotGridEh.ColumnAxisOptions.TotalsBeforeData property to True for column axis cells.

Automatically increase the height of the cell to fit all the text in the cell

To activate the automatic grid height increase mode, set the TPivotGridEh.RowAxisOptions.HeightAutoExpand property to True for row axis cells or TPivotGridEh.ColumnAxisOptions.HeightAutoExpand to True for column axis cells.

Arrange multiple data cells in a vertical row section

To activate the mode of arranging multiple cells with data (when the TPivotDataSourceEh.ValueFieldDefs collection contains multiple values) vertically, set the pgoMultiValuesInRowsAxisEh value in the TPivotGridEh.Options property.