'DeclarationPublic Event BeforeSubtotal As SubtotalEventHandler
public event SubtotalEventHandler BeforeSubtotal
Event Data
The event handler receives an argument of type SubtotalEventArgs containing data related to this event. The following SubtotalEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| AggregateValue | Gets or sets the calculated aggregate value for the group. |
| Bottom | Gets the index of the bottom row in the group. |
| Cancel | Whether to cancel the creation of the new subtotal row. |
| Caption | Gets or sets the text to insert in the new subtotal row. |
| Function | Gets the AggregateEnum value that specifies the type of aggregate to calculate.. |
| GroupFrom | Gets the index of the first column in the range used to detect group breaks. |
| GroupTo | Gets the index of the last column in the range used to detect group breaks. |
| IsNewRow | Gets a value that determines whether the subtotal row is a new row or the subtotal is being added to an existing subtotal row. |
| Level | Outline level to assign to the new subtotal rows. |
| NewRowIndex | Gets the index of the new subtotal row. |
| Style | Gets or sets the CellStyle to be applied to the new subotal row. |
| Top | Gets the index of the top row in the group. |
| TotalOn | Gets the index of the column that contains values being aggregated. |
Remarks
Subtotal rows are added when the Subtotal(AggregateEnum,Int32,Int32,Int32,Int32,String,AggregateFlags) method is invoked.
The event handler may prevent the grid from adding a particular row, or it may customize the caption, style, and aggregate value used in the new subtotal row.
See Also