Specifies either the data type of a column in a PivotTable cache, or the data type of a PivotTable field for non-OLAP data sources.
For a PivotTable cache, the following attributes can be specified.
Attribute | Description |
dt:type | Optional. Contains one of the following string constants specifying the base data type of the field: Bin.Hex, Boolean, DateTime, Float, I1, I2, I8, Int, String, UI1, UI2, UI4, or UI8. If this attribute is not specified, the default type is String. |
dt:maxLength | Optional. Length of a string field. If this attribute is not specified, the default length for string fields is 255. |
Contained In
AttributeType,
PivotField,
PLPivotField
Remarks
For a PivotTable field, this element contains one of the following string constants specifying the data type: Boolean, Date, Integer, Number, or Text. Boolean can be specified only when the PLExport element is specified for the PivotTable report and the report data comes from a PivotList component. If the DataType element is not specified, the default data type is Text.
See the examples in the PivotCache and PivotTable element topics.