VSView Reporting Edition Reference > Field Object > Field Properties > Calculated Property |
Returns or sets whether the Text property should be interpreted as a literal value or as a calculated expression.
field.Calculated[ = {True | False} ]
If this property is set to False, the value of the Text property is rendered on the report without any further processing. If it is set to True, the value of the Text property is evaluated as a VBScript expression and the result of the expression is rendered on the report.
For example, assuming that the report has a source recordset with fields named Amount and SalesTax:
theField.Text = "Amount * SalesTax"
theField.Calculated = False
Debug.Print Field.Value
Amount * SalesTax
theField.Text = "Amount * SalesTax"
theField.Calculated = True
Debug.Print Field.Value
257.34
Boolean