This document describes the Expression Editor used for constructing expressions in the End-User Report Designer.
The Expression Editor provides a variety of aggregate, date-time, logical, math and string functions. You can also use logical and arithmetic operators, fields of a data source to which a report is bound, report elements, constants, and variables.
This editor supports syntax highlighting and intelligent code completion (suggesting functions and available data elements as you type).
An error icon appears if an expression contains any errors. Hovering over this icon with the mouse invokes the popup indicating the error's position.
Take into account the following syntax conventions when using the Expression Editor:
When expression bindings are enabled in your reports, the Report Designer contains the Expressions tab allowing you to assign values to various element properties. Clicking any property's ellipsis button invokes the Expression Editor, in which you can specify custom expressions with the available data fields.
In the legacy binding mode, you can use the Expression Editor in the following cases:
Edit a Calculated Field's Expression
Specify a Query Parameter's Value
In the Configure Query Parameters wizard page, set the parameter type to Expression and click the Value property's the ellipsis button.
Construct a Formatting Rule's Condition