This document describes the Expression Editor used for constructing expressions in the Report Designer.

Expression Editor Overview

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.

Expression Syntax

  • Take into account the following syntax conventions when using the Expression Editor:
  • Reference a data field in the expression by enclosing its name in the square brackets (for example, [ProductName]).
  • Denote string values with apostrophes. Type a double apostrophe to embed an apostrophe into an expression’s text (for example, ‘It’‘s sample text’).
  • Enclose date-time constants with hashtags ([OrderDate] >= #1/1/2016#).
  • Use a question mark to specify a null reference (one that does not refer to any object) ([Region] != ?).
  • If an expression involves the use of different types, you can convert them to the same type using dedicated functions (for instance, Max(ToDecimal([Quantity]),[UnitPrice])).

Using the Expression Editor

You can use the Expression Editor in the following cases:

  • Edit a Calculated Field’s Expression
    Access a calculated field’s settings in the Field List and click Expression property’s ellipsis button.
  • Construct a Formatting Rule’s Condition
    Access the formatting rule’s settings in the Properties panel and click the Condition property’s ellipsis button.
Revision: 2
Last modified: Sep 19, 2019


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment