In Interactive Viewer, you can use the expression builder to enable the viewer to construct an expression for you, or you can construct a custom expression by selecting Advanced in the Category field. The expression you create is used to compute the new calculated column that appears in the report.
1 Select the column to the left of where you want to place the new computed column. From the context menu, choose Column→New Computed Column. New Computed Column appears.
2 In Column Label, type a name for the new computed column. The name you specify appears in the column header.
5 Based on the function you select, one or more column fields appears. In each Column field that appears, select a column from the list.Choose OK. The new computed column based on the expression you built, appears in the report.
To use a data field in the expression, type the left bracket ([), then select the required field from the list that appears. The list displays only fields in the report.
To use a function, type the first letter of the function, then select the function from the list that appears. The functions indicate the arguments, if any, that you need to specify.
2 After you complete typing the expression, choose Validate. If the expression is syntactically correct, Information appears informing you that the expression is valid, as shown in Figure 6-4.
Figure 6-4 Select the computed column. From the context menu, choose Column→Edit Computed Column. New Computed Column appears. To modify the expression, continue as described in the previous section.
|
|
Copyright Actuate Corporation 2012 |