PivotGridFieldBase.UnboundExpressionMode Property

Gets or sets how the specified data field’s unbound expression is calculated.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v24.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

C#

[DefaultValue(UnboundExpressionMode.Default)]
public UnboundExpressionMode UnboundExpressionMode { get; set; }

VB.NET

<DefaultValue(UnboundExpressionMode.Default)>
Public Property UnboundExpressionMode As UnboundExpressionMode

Property Value

Type	Default	Description
UnboundExpressionMode	Default	An UnboundExpressionMode object that specifies how the specified data field’s unbound expression is calculated.

Available values:

Name	Description
Default	The default parameter value.
UseSummaryValues	An unbound expression is calculated against summary values.
DataSource	An unbound expression is calculated against each data source record, and then the resulting values are summarized.
UseAggregateFunctions	An unbound expression is calculated using aggregates.

Remarks

Note

This member is not supported in Optimized, OLAP, and Server modes. Use ExpressionDataBinding/OlAPExpressionBinding instead.

By default, the unbound expression is calculated against each data source record, and then the resulting values are summarized. If necessary, you can calculate unbound field values on the visualization (or summary) level. You can also use a specified set of summary functions (such as Sum, Avg, etc.) to summarize data source records. The UnboundExpressionMode property allows you to specify the mode used to calculate unbound field values.

To learn more, see Unbound Fields.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the UnboundExpressionMode 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.

C#

winforms-pivotgrid--display-the-difference-of-income-and-outlay-in-totals/CS/PivotGridCustomSummaryExample/Form1.cs#L76

    fieldValueTotal.UnboundType = DevExpress.Data.UnboundColumnType.Decimal;
    fieldValueTotal.UnboundExpressionMode = UnboundExpressionMode.UseAggregateFunctions;
}

VB.NET

winforms-pivotgrid--display-the-difference-of-income-and-outlay-in-totals/VB/PivotGridCustomSummaryExample/Form1.vb#L62

    fieldValueTotal.UnboundType = DevExpress.Data.UnboundColumnType.Decimal
    fieldValueTotal.UnboundExpressionMode = UnboundExpressionMode.UseAggregateFunctions
End Sub