Grouping

See the overview for more details.

Public Function Grouping_CurrentMatchVal(GroupDefIndex As Integer) As Variant

The current value for the group with the passed in index.


Public Function Grouping_IsFirstGroupRow(GroupDefIndex As Integer, Optional RowIndex As Long = -1) As Boolean

Is this the first row in the group ?

Public Function Grouping_IsLastGroupRow(GroupDefIndex As Integer, Optional RowIndex As Long = -1, Optional SkipLastRec As Boolean = False) As Boolean

Is this the last row in the group ?

Public Sub Grouping_SetCurrentMatchVals(Optional RowIndex As Long = -1)

Calculates the grouping membership and boundaries for a particular row. A group is the range of rows having the same value in the column associated with the group definition column.


Public Sub Grouping_SetMatchColumnNames(ColNames As String)

Sets up grouping on the passed column names.
Group definitions are set up one per column, in the same order as the columns are passed.
Group definitions will be referenced using a group index from 1 to the number of group definitions.