To customize values displayed in the group headers and footers, you can use custom formulas. Formulas have simple VB-like syntax and can greatly improve your application appearance and functionality.

Formula operators 

+	Addition
-	Subtraction
*	Multiplication
/	Division
&	String concatenation
( and )	Subexpression grouping

 

Predefined read-only variables and functions

GroupingValue	Current group's grouping value.
ChildCount	Number of first level child rows.
TotalChildCount	Number of rows in the group (in all sublevels).
HeaderCaption	Value of the group's HeaderCaption property.
FooterCaption	Value of the group's FooterCaption property.
GroupColCaption	Value of the grouped column's Caption property.
GroupCalc(index)	Returns group calculation result. index is the index of the calculation in the Calculations collection.
Format(val, format)	Formats val value according to the VB-like format specified in the format parameter. Available only if host application provides Visual Basic formatting capabilities.

 

Following sample shows how to display count of child rows in the group footer.

Dim grp As SGGroup
Set grp = SGGrid1.Groups(1)
grp.FooterTextSource = sgGrpFooterFormula
grp.FooterFormula = "'Child row count is ' & ChildCount"