Skip to main content

CalculatedField.Expression Property

Specifies the expression of the calculated field.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v23.1.dll

NuGet Package: DevExpress.Reporting.Core


public string Expression { get; set; }

Property Value

Type Default Description
String String.Empty

A String containing a calculated field’s expression.


Use the Expression property, to specify an expression for a calculated field. at design time within Visual Studio, this property provides access to the Expression Editor.

HowTo - CreateCalcField_3

For the expressions, numerous date-time, logical, math and string functions, operators and constants are supported. For a complete list of these functions, refer to Expressions.

You can calculate aggregated functions in a calculated field expression, as well.

To refer to a data field (that is specified by the CalculatedField.DataSource and CalculatedField.DataMember properties) within an expression, enclose its name in [square brackets]. And, parameters are inserted using a question mark before their names.

A calculated field’s expression also can evaluate the values of other calculated fields.

Date-time constants must be wrapped in #hashes# ([OrderDate] >= #1/1/2009#). To represent a null reference (one that does not refer to any object), use a question mark ([Region] != ?). And, to denote strings, use apostrophes, otherwise, an error occurs.

The type of value returned by a calculated field is defined by its CalculatedField.FieldType property.

To learn more, refer to Calculated Fields Overview.

For a code example, refer to Creating a Calculated Field (Runtime Sample).

See Also