All docs
V21.1
21.2 (EAP/Beta)
21.1
20.2
The page you are viewing does not exist in version 20.2. This link will take you to the root page.
20.1
The page you are viewing does not exist in version 20.1. This link will take you to the root page.
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

Expressions Overview

  • 3 minutes to read

Use expressions to accomplish the following tasks:

Watch Video: Expression Basics

How to Specify an Expression

In the Report Designer, properties that support expressions have an ellipsis button in the value editor. Click this button to invoke the Expression Editor.

property-editor-ellipsis-button

As an alternative, you can use the Properties window to specify an expression for a report, band, or control. The Properties window lists all properties that support expressions in a separate tab. Select a report, band, or control, and switch the Properties window to the Expressions tab to access these properties.

property-grid-expression-tab

In ExpressionsAdvanced mode, the Report Designer allows you to specify expressions that are evaluated within specific events:

  • The BeforePrint event where you can use data fields from all queries in the data source.
  • The PrintOnPage event fetches the number of pages in the report and the current page. You can use these variables to specify conditions for report items.

See the following topic for more information: Data Binding Modes.

At runtime, XtraReport, Band, and XRControl objects have a collection of expression bindings. Each element from this collection binds the object’s property with an expression that specifies the property’s value. Specify elements in this collection to bind the object’s properties to data.

Expression Editor

The Report Designer’s Expression Editor allows you to use functions, operators, data source fields, report elements, constants, and variables to construct expressions.

Expressions_ExpressionEditor

The Expression Editor highlights an expression’s syntax and supports intelligent code completion (which suggests functions and available data elements as you type).

Expressions_ExpressionEditor_Intellisense

The Expression Editor displays all the errors it finds in the created expression.

Expressions_ExpressionEditor_ErrorValidation

FilterString Editor

You can use the Report Designer’s FilterString Editor to specify the FilterString property of a report, XRCrossTab, or XRChart‘s Series.

The FilterString Editor‘s visual interface allows you to use an unlimited number of conditions and combine them with logical operators to create filter criteria. You can also switch to Text mode and type a filter string.

Expressions_FilterEditor

The FilterString Editor highlights an expression’s syntax and supports intelligent code completion (which suggests functions and available data elements as you type).

FilterEditor_New_Features

Expression Syntax

An expression can include field names, constants, operators, functions, data fields, and parameters.

See the following topic for more information: Expression Language.

Refer to the CustomFunctions class description for information on how to implement a custom expression function in your reporting application.