To add a computed field to a report or label

 

1.Double-click the Computed Fields item.

2.In the Add Computed Field dialog box, set the following fields:

•Name – the name given to this computed field

•Operation - the type of operation that will be used in this computed field

•Running – the status of the running property (see description below)

•Over – the area of reference that will be used in this computed field

•Type – the type of value that will be used in this computed field

•Value – the base expression that will be used in this computed field

•Initial Value -  the initial expression that will be used in this computed field (only available under certain conditions)

•Step Value – the step expression that will be used in this computed field (only available under certain conditions)

3.Click OK.

 

Available Operation values are Count, Sum, Average, Minimum, Maximum, First, Last, Variance, Standard Deviation, Variance / Population, Standard Deviation / Population, and Counter.

 

Available Running values are Yes and No. The Running property is used to calculate record by record or group by group statistics in a report. The running values are accumulated for the range specified by the computed field. For example, you can calculate record by record statistics by using a computed field with the Running property set to Yes in the Detail section of the report. Note that computed fields cannot be calculated over a page-level grouping if the Running property is set to Yes; the Running property is only valid for Report, Detail, and user-created groupings.

 

Available Over values are Page, Report, and Detail, as well as any user-created groupings. Page will perform the selected operation on the records contained on each individual page. Report will perform the selected operation on all the records contained in the entire report. Detail will perform the selected operation on each record contained in the entire report. User-created grouping will perform the selected operation on the records contained in each individual grouping. Note that the Running property cannot be applied if you select Page as your Over value.

 

Available Type values are Double, Float, Integer, Long, Short, Byte, Big Decimal, String, Boolean, Date, Time, Timestamp, and Object. Note that not all types are available for all operations.

 

Available Value values are anything contained in the drop-down list, and any legal characters or expressions that you type into the field. For example, you could select the [Quantity] field from the drop-down list, then add a mathematical expression like *100. The resulting value would be [Quantity]*100, or the value of the [Quantity] field multiplied by 100.

 

To edit a computed field

 

1.Right-click the computed field you want to edit, and click Edit Computed Field.

2.Edit the computed field’s properties as required.

 

To rename a computed field

 

1.Click the to expand the Computed Fields item.

2.Right-click the computed field you want to rename, and click Rename Computed Field.

3.Type a new name for the computed field in the edit field.

 

To duplicate a computed field

 

1.Click the to expand the Computed Fields item.

2.Right-click the computed field you want to duplicate, and click Duplicate Computed Field. A copy of the computed field appears in the list.

 

To delete a computed field

 

1.Right-click the computed field you want to delete, and click Delete Computed Field.

2.In the Delete Confirmation dialog box, click Yes.