Format Element (ASSL)


Applies To: SQL Server 2016 Preview

Contains the required format of the DataItem element.


Data type and lengthString
Default valueNone
Cardinality0-1: Optional element that can occur once and only once.
Parent elementDataItem
Child elementsNone

Allowed values for the Format element are Microsoft Office Excel formats, and the strings TrimRight, TrimLeft, TrimAll, and TrimNone. For trimming, TrimRight is the default.

The value of this element is limited to one of the strings in the following table.

Any Excel format stringData is formatted according to the specified named or custom format string. Any format string that Excel supports can be supplied.
TrimAllData is trimmed on the left and right.
TrimLeftData is trimmed on the left.
TrimNoneData is not trimmed.
TrimRightData is trimmed on the right.

The element that corresponds to the parent of Format in the Analysis Management Objects (AMO) object model is DataItem.

Properties (ASSL)

Community Additions