TcxPivotGridField.DisplayFormat Property

Specifies the formatting pattern used to display field values.

Declaration

property DisplayFormat: string read; write;

Property Value

Type
string

Remarks

Use the DisplayFormat property to specify the format string that will be used to display field values within data cells. If this property is set to an empty string, the formatting pattern is determined automatically depending on the field’s summary variation mode as follows:

• In percentage and variation percentage modes (corresponds to the svPercentOfColumn, svPercentOfRow, or svPercent value of the SummaryVariation property), the formatting pattern is specified by the cxPivotGridDefaultFieldPercentFormat global constant.

• Otherwise, the formatting pattern is determined according to the type of field values:

• For floating-point values, the default formatting pattern is specified by the cxPivotGridDefaultFieldFloatFormat global constant;

• For ordinal values (such as an integer or Boolean type), the default formatting pattern is specified by the cxPivotGridDefaultFieldIntFormat global constant;

• For currency values, the formatting pattern is specified by the CurrencyFormat property of an object returned by the cxFormatController global function.

Refer to the TNumericField.DisplayFormat property’s topic in the Delphi (C++ Builder) documentation for more information on formatting values.