Defines the type of the format in which the value is presented in a field.

Remarks

Property specifies the data type in which the field’s values are displayed in the control. The value selected in this property is also important for the evaluation of expression that determines the string format defined in property FormatString.

Several options are available

 

Data Type	Description
None	No data type is used when evaluating the defined string format.
DateTime	DateTime data type is used to correctly evaluate the expression defined as the string format.
Numeric	Numeric data type is used to correctly evaluate the expression defined as the string format.

The default value for this property is None.

Example (MxSpace)

To see the defined FormatType property on a pivot field open MxSpace solution project in Visual Studio. In Solution Explorer expand node Parts and double click WorkOrderAnalysisPart.cs. Click the pivot control and run its designer. Field ActualQuantity has FormatType property set to Numeric so that its values are presented with only two decimal digits.

To define FormatType property

1. In Solution Explorer open MxPart component (WorkOrderAnalysisPart) which contains Pivot control.
2. Right click the control and select option Run Designer.
3. Select the desired field (ActualQuantity) in Pivot Fields section. 
4. Set the desired value (Numeric) for property FormatType.

See Also