Returns or sets whether subtotals should be inserted above or below the totaled data.
Syntax
[form!]VSFlexGrid.SubtotalPosition[ = SubtotalPositionSettings ]
Remarks
The settings for the SubtotalPosition property are described below:
|
Constant |
Value |
Description |
|
flexSTBelow |
0 |
Subtotals are inserted below the data. This setting creates grids that look like reports. |
|
flexSTAbove |
1 |
Subtotals are inserted above the data. This setting creates grids that look like outline trees (this is the default value). |
The SubtotalPosition property affects the placement of subtotals added using the Subtotal method and also the appearance and behavior of the OutlineBar. When SubtotalPosition is set to flexSTAbove, parent nodes appear at the top of the grid, like a standard tree control. When SubtotalPosition is set to flexSTBelow, parent nodes appear at the bottom of the grid, giving the tree an upside-down appearance.
The example below shows how to insert a subtotal positioned below the calculated values:
Private Sub Form_Load()
fg.rows=3
fg.TextMatrix(1, 1)="Rent": fg.TextMatrix(1, 2)="234"
fg.TextMatrix(2, 1)="Rent": fg.TextMatrix(2, 2)="335"
fg.SubtotalPosition = flexSTBelow
fg.Subtotal flexSTSum, 1, 2
End Sub
Data Type
SubtotalPositionSettings (Enumeration)
Default Value
flexSTAbove (1)