How to: Perform Calculations in Field Controls

  • Article

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

  1. Open the report or label in the appropriate designer.

  2. In the designer, right-click on the Field control and select Properties… from the context menu.

  3. In the Field Properties dialog box, select the Calculate tab.

  4. Select a Calculation type.

  5. 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

Reference

Calculate Field Dialog Box