FlexGrid for WinForms
Subtotal(AggregateEnum,Int32,String,String,String) Method



AggregateEnum value that specifies the type of aggregate to calculate.
Outline level to assign to the new subtotal rows. This parameter allows the creation of multi-level subtotals and affects the display of the outline tree.
Name column used to detect group breaks.
Name of the column that contains values to be aggregated (usually numeric).
Text to insert in the subtotal rows.
Groups rows based on cell contents and calculates aggregate values.
Syntax
'Declaration
 
Public Overloads Sub Subtotal( _
   ByVal aggType As AggregateEnum, _
   ByVal level As Integer, _
   ByVal groupOn As String, _
   ByVal totalOn As String, _
   ByVal caption As String _
) 
'Usage
 
Dim instance As C1FlexGridBase
Dim aggType As AggregateEnum
Dim level As Integer
Dim groupOn As String
Dim totalOn As String
Dim caption As String
 
instance.Subtotal(aggType, level, groupOn, totalOn, caption)

Parameters

aggType
AggregateEnum value that specifies the type of aggregate to calculate.
level
Outline level to assign to the new subtotal rows. This parameter allows the creation of multi-level subtotals and affects the display of the outline tree.
groupOn
Name column used to detect group breaks.
totalOn
Name of the column that contains values to be aggregated (usually numeric).
caption
Text to insert in the subtotal rows.
Remarks
This is a variant of the Subtotal(AggregateEnum,Int32,Int32,Int32,String) method that takes column names instead of indices.
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

C1FlexGridBase Class
C1FlexGridBase Members
Overload List

 

 


Copyright (c) GrapeCity, inc. All rights reserved.

Send Feedback