ComponentOne True DataControl 8.0

PivotFieldsAllLevels Property (TDataLite)

In pivot mode, TData control exposes a hierarchical recordset. Each hierarchy level corresponds to a row dimension, the depth of the hierarchy equals the number of fields in PivotRowDimensions.

Syntax

TData.PivotFieldsAllLevels = boolean

Remarks

Read/Write at design time. Read-only at run time. Property applies to TDataLite control. Not available in TData control.

This property applies to Pivot mode. If this property is set to False, every level except the last (deepest) one contains only one field, the row dimension field of that level. The last (terminal) level contains the last row dimension field and all crosstab fields generated by the column dimension field. This field structure is most suitable for displaying the hierarchical recordset in TreeView-like bound controls.

If this property is set to True (default), every level contains all fields: all row dimension fields and all crosstab fields. On non-terminal levels (all levels but last), fields belonging to lower levels of the hierarchy contain totals, aggregated values. This structure is more suitable for displaying the hierarchical recordset in a bound grid where all rows contain all the fields.

Using Pivot mode with ComponentOne True DBGrid 8.0 (preferred choice for TData pivot mode), set this property to True. Using other, third-party bound controls, set this property in accordance with those controls’ requirements, in most cases – to False.

For more information, see OLAP: Decision Support, Pivot Table.

See Also

TDataLite Control