CalculatedField.Expression Property

Specifies the expression of the calculated field.

Namespace: DevExpress.XtraReports.UI

Assembly: DevExpress.XtraReports.v18.1.dll

Declaration

[SRCategory(ReportStringId.CatData)]
public string Expression { get; set; }
<SRCategory(ReportStringId.CatData)>
Public Property Expression As String

Property Value

Type Description
String

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 the "Parameters." prefix 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