Using the group calculation type sgCalcList when grouping allows you to create and display a list of data "conditionally" based off the data values of another column. This type is also used in conjunction with the ListSeperator property, which is used to define the separator used to separate the list values.

For example, we have the following grid that we will later group by the month column:

Notice that some invoices in the grid have a paid balance of zero.

Next we want create a group with the month column and use the group calculation type sgCalcList to display the list of invoices per group that have an unpaid balance.

Notice we have two groups. The first, "January," is expanded, and the second, "February," is collapsed. Also notice the invoices that equal zero for each group are displayed in the group header of the group.

The code below was used to create the calculated grouping displayed above:

'create a group on the month column
Set grp = SGGrid1.Groups.Add("Month", _
sgSortAscending, sgSortTypeNumber, True, False)

'use formulas for header and footer text
grp.HeaderTextSource = sgGrpHdrFormula
grp.FooterTextSource = sgGrpFooterFormula

'create calculations
grp.Calculations.Add sgCalcAverage, "Amount"
grp.Calculations.Add sgCalcSum, "Amount"
grp.Calculations.Add sgCalcSum, "Amount", "Paid", sgOpEqual, 0
grp.Calculations.Add sgCalcMinimum, "Day"
 
'The line of code below will create a list of values from our "Invoice" column where the ‘value in the "Paid" column equals 0.
With grp.Calculations.Add(sgCalcList, "Invoice", "Paid", sgOpEqual, 0)
   'here we specify what we want the list items to be separated by
   .ListSeparator = ", "
End With

'use calculations in formulas
grp.HeaderFormula = "Format(GroupCalc(5),'mmmm') & ' - Invoices: ' " & _
"& GroupCalc(4) & ' (unpaid ' & Format(GroupCalc(3),'Currency') & ')'"
grp.FooterFormula = "'Average: ' & Format(GroupCalc(1),'Currency') & " & _
"' Total: ' & Format(GroupCalc(2),'Currency')"
'clean up
Set grp = Nothing
'refresh the groups 
SGGrid1.RefreshGroups sgCollapseGroups

You can find additional information about the use of the sgCalcList type, and ListSeperator property from the links to our help file below.

sgCalcList:

ListSeperator:

The attached sample uses the code above to display a sgCalcList of values from the "Invoice" column where the value in the "Paid" column equals 0 in our group heading.