ExpressionBindingBase.Expression Property

Gets or sets a string expression to calculate.

Namespace: DevExpress.PivotGrid.DataBinding

Assembly: DevExpress.PivotGrid.v22.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design

Declaration

C#

[DefaultValue("")]
public string Expression { get; set; }

VB.NET

<DefaultValue("")>
Public Property Expression As String

Property Value

Type	Default	Description
String	String.Empty	A string expression.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Expression 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-pivot-grid-provide-custom-summary-values-for-cells/CS/WinPivotCustomSummaryCellType/Form1.cs#L12

ExpressionDataBinding expression = new ExpressionDataBinding();
expression.Expression = "Iif(IsTotal([fieldCompanyName]), 'Grand Total', IsTotal([fieldYear]), 'Grand Total', IsTotal([fieldProductName]), 'Total', IsTotal([fieldQuarter]), 'Total', Sum([ProductAmount]))";
fieldProductAmount.DataBinding = expression;

VB.NET

winforms-pivot-grid-provide-custom-summary-values-for-cells/VB/VBWinPivotCustomSummaryCellType/Form1.vb#L11

Dim expression As New ExpressionDataBinding()
expression.Expression = "Iif(IsTotal([fieldCompanyName]), 'Grand Total', IsTotal([fieldYear]), 'Grand Total', IsTotal([fieldProductName]), 'Total', IsTotal([fieldQuarter]), 'Total', Sum([ProductAmount]))"
fieldProductAmount1.DataBinding = expression