- Select the first empty row and, in Name, specify a unique name for the column binding.
- In Data Type, select a data type appropriate for the data returned by the expression you specify next. If you are not sure what the data type is, use the default type, Any.
- In Expression, specify the expression that indicates the data to return, using one of the following methods:
- Type the expression directly in the Expression field.
- If you need help constructing the expression, click in the empty field, then choose the ellipsis button to launch Expression Builder. Figure 4-2 shows an expression in Expression Builder that combines the values of two data-set fields selected from the Customers data set. Choose OK when you finish constructing the expression.
Figure 4-2 Expression Builder showing a column-binding expression
- In Aggregate On, use the default value, N/A. The Aggregate On option applies only to aggregate expressions that perform calculations over a specified set of data rows.