Expression Builder in Web Report Designer
The Expression Builder in Bold Reports® Web Report Designer lets you write expressions that control the content, style, data, value, and behavior of your reports. Expressions must start with an equal sign (=). Otherwise, the value is treated as a string literal.
How do I set an expression?
You set an expression in the Web Report Designer by picking items from the two drop-down lists in the Expression Builder.
- Choose Options from the first drop-down list to set an expression with Built-in-fields, Operators, and Functions.
- Choose Data from the second drop-down list to set an expression with Parameters and Dataset Fields.
Which expressions are supported?
The Web Report Designer supports the expression types and functions listed in the following table:
| References | Description | Example |
|---|---|---|
| Built-in-fields | Built-in fields collection are the global variables that are used in a report to specify the report name, page number, execution time. It includes Globals and the User collections. | =Globals!ExecutionTime |
| Operators | An operator is a symbol that represents to perform simple basic operation. It is used to combine references in an expression. | =Globals!ExecutionTime+User!UserID |
| Functions | Functions in an expressions is used to perform some basic functions like datetime, math, aggregate, text functions, conversion functions. | =Round(1.3*5)/5 |
| Parameters | Represents the collection of report parameters, each of which with a parameter value. | Parameters!ReportParameter1.Value |
| Dataset Fields | Represents dataset fields collections in reports with dataset field value. | Fields!EmployeeID.Value,"DataSet1" |
Note: Write expressions in a single line format, not in multiple lines.