Expressions can be written to link two fields into one field, for example the number of units accomplished and the description.

1. Drag a text box and enter the field name in it.
2. Drag another text box next to it and select it.
3. Click the Properties tab and click the Data Binding icon next to the Value field in the Input section.
4. Select Expression.

The two fields are now linked

5. Click Save and Preview. See Preview a Report for more information.

You can use expressions in properties like color, font, border, etc... on specific field values based on a condition, to highlight a part of data.

1. Select a field, for example Stage in your report, and go to your Properties tab.
2. In the Common section, click the Data Binding icon to the right of the Value field.
3. Click Expression.
4. Enter an expression, for example: {Switch(stage = "ACTUAL", "Actual", stage = "PROPOSED", "Proposed")}

5. Click Save and Preview. See Preview a Report for more information.

You can make field color conditional upon the value through an expression in the color property.

1. Select a field and click the Properties tab.
2. In the Text section, click the Data Binding icon to the right of the Color field.
3. Click Expression and enter one. For example, {iif(stage = "ACTUAL", "HotPink", "Black")} would change the font to hot pink.
4. Click Save and Preview. See Preview a Report for more information.

You can create an expression to have your report only pull work activities that are past due. With this expression, the report will update as new work activities become past due so it is always current.

1. Click in a group and select Details on the Groups panel that appears.
2. Click the Properties tab.
3. In the Group section, click Add in the Filters field.

4. Under the All Of, click Add and select projfinishdate.
5. Select Less Than Or Equal To next to it.
6. Click the Options icon in the empty field to the right.
7. Click Expression.
8. Expand Common Values and double-click Current Date and Time to add it to the Expression.

9. Click Save.
10. Click Save and Preview. See Preview a Report for more information.