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.

To specify that a cumulative calculation be applied to a Field control

See Also

Tasks

Reference