How to: Perform Calculations in Field Controls
You can change the rendered value of a field control by specifying that a cumulative calculation be performed and the results displayed in place of the field expression value.
To specify that a cumulative calculation be applied to a Field control
Open the report or label in the appropriate designer.
In the designer, right-click on the Field control and select Properties… from the context menu.
In the Field Properties dialog box, select the Calculate tab.
Select a Calculation type.
Select a Reset based on option.
For detailed information on the behavior of each calculation type, see Calculate Field Dialog Box.
Note
If the _REPORTBUILDER system variable is not set to the default Report Builder or is set to a third-party builder, the report control dialog box displays or a different dialog box might display. For more information, see _REPORTBUILDER System Variable and Report Expression Dialog Box.
See Also
Tasks
How to: Add Field Controls to Reports