CREATETOTALS Function (Report)
Maintains totals for a variable in the same way as totals are maintained for fields by using the TotalFields Property.
CREATETOTALS(Var1 [, Var2] ,...)
Parameters
- Var1, Var2, …
-
Type: Decimal
Similar to the TotalFields Property, CREATETOTALS maintains group and grand totals. The totals can be printed by placing controls that have the variable or variables that are the arguments of CREATETOTALS as their source expressions in the appropriate sections. The group totals are printed in GroupFooter sections, and the grand totals are printed in Footer sections.
This function is not supported on client report definition (RDLC) report layouts. In most cases, when you create a layout suggestion for a Classic report layout that uses the CREATETOTALS function, a SUM expression is created instead and no action is required.