Skip to main content
A newer version of this page is available. .

CalculatedField.Expression Property

Specifies the expression of the calculated field.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v20.2.dll


public string Expression { get; set; }

Property Value

Type Default Description


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