TCustomDataStore.DataSet Property

Specifies the dataset that provides the fields which make up the dimensions and summaries maintained by the crosstabulated data store.

Pascal

property DataSet: TDataSet;

C++

__property TDataSet DataSet;

Description

Set DataSet to the dataset that contains the crosstabulated data for the data store. Usually, DataSet is a TDecisionQuery object. TDecisionQuery objects are SQL queries that are grouped appropriately to calculate summaries for a crosstabulated data store.

The DataSet property can also be set to a TQuery object where the SQL has the same form as that of a TDecisionQuery or to any other dataset that contains summarized values in the same structure as the result of a TDecisionQuery query.

If the DataSet property is a TQuery or TDecisionQuery object, the crosstabulated data store automatically determines which fields are dimensions and which are summaries. If the DataSet property is not a query, the fields in the dimension map must be explicitly identified as dimensions or summaries, and, if they represent summaries, the type of summary must be indicated.

Note: The summary values for the crosstabulated data store must be calculated by the TDataSet object. The data store does not summarize raw data, but analyzes summarized data into dimensions.