Add calculated field

Calculated fields can be added to dataset of data source such as database, UDS, XML, CSV, Dynamic and SAP dataset.

1.Select [Add Calculated Field] from the right mouse click popup menu on the dataset under [DATABASE] in the data window.

2.Enter "Field Name" and check "Script Type" in the Add Calculated Field dialog.

3.The calculated field appears in the data window.

Note

If configure conditions in a query using calculated fields, the parameter input dialog will show empty calculated field value at query runtime.