PivotOpen Method (TDataLite)

True DataControl 8.0 Reference> True DataControl Lite Control> TData Control Methods> PivotOpen Method (TDataLite)

In pivot mode, opens pivot query.

Syntax

TData.PivotOpen [Query]

Remarks

Method applies to TDataLite control. Not available in TData control.

Arguments: Query is an optional string argument. If it is specified, it determines a multidimensional query (MDX). If it is omitted or empty, the query is generated automatically based on the values of PivotRowDimensions /PivotColumnDimension /PivotMeasure properties.

Return Value: None

This method applies to Pivot mode. It is called to generate the end-user query, execute it and fill the resulting hierarchical crosstab recordset. Normally, the query is generated automatically based on the values of PivotRowDimensions /PivotColumnDimension /PivotMeasure properties. As an advanced option, the full text of a query can be specified explicitly in the optional Query argument. In both cases, the resulting query text can be retrieved using the PivotQuery property.

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