PivotGridField.UnboundType Property

Gets or sets the data type and binding mode of the field. This is a dependency property.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v23.2.dll

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

C#

public FieldUnboundColumnType UnboundType { get; set; }

VB.NET

Public Property UnboundType As FieldUnboundColumnType

Property Value

Type	Description
FieldUnboundColumnType	A FieldUnboundColumnType enumeration value representing the data type and binding mode of the field.

Available values:

Name	Description
Bound	Indicates that the column is bound to a field in the control’s underlying data source. The type of data this column contains is determined by the bound field.
Integer	Indicates that the column is unbound and it contains integer values (the Int32 type).
Decimal	Indicates that the column is unbound and it contains decimal values (the Decimal type).
DateTime	Indicates that the column is unbound and it contains date/time values (the DateTime type).
String	Indicates that the column is unbound and it contains string values (the String type).
Boolean	Indicates that the column is unbound and it contains Boolean values (the Boolean type).
Object	Indicates that the column is unbound and it contains values of any type. A TextEdit editor is assigned for the in-place editing of such a column.

Remarks

The DXPivotGrid supports unbound fields. These fields are not bound to any field in the control’s data source which is specified by the PivotGridControl.DataSource property.

You can provide data for unbound fields using one of two methods:

• via the PivotGridField.UnboundExpression property.

  This specifies a formula in a string form used to evaluate the field’s values.

• by handling the PivotGridControl.CustomUnboundFieldData event.

  This approach allows you to implement complex algorithms for populating unbound fields.

To make a field unbound, set its UnboundType property to a FieldUnboundColumnType value that corresponds to the type of data that the field will display. For instance, if the field is supposed to display integer values, set the UnboundType property to FieldUnboundColumnType.Integer.

See the FieldUnboundColumnType topic for information on the available data types for unbound fields. The data type specified by the UnboundType property determines how field values are sorted.

If the field’s UnboundType property is set to FieldUnboundColumnType.Bound, it’s assumed that this field is not unbound and it is bound to a specific field in the data source, specified by the PivotGridField.FieldName property.

The PivotGridField.FieldName property’s value of an unbound field must be unique, and not match any field name in the underlying data source.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the UnboundType property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

XAML

wpf-pivotgrid-hide-column-totals/CS/HowToBindToMDB/MainWindow.xaml#L18

                     CellFormat="p"/>
<dxpg:PivotGridField Name="fieldTotalSum" UnboundType="Decimal" Area="DataArea"
                     Caption="Total Sum"/>