Previous Topic

Next Topic

Book Contents

Book Index

FD Tutorial: Totalling for List Grids

List Grid Component

Property: AllowTotals (Boolean)

Needs to be set to true to allow totals on the grid

Property: GridTotalled (Boolean)

Boolean toggle to turn grid totalling on based on AllowTotals being true

Method: GetTotalValue (Number)

Method that takes in a string of the field and returns the total value if the grid has been totalled

gridListGrid1.GetTotalValue("ExclusiveAmountBs")

Returns null if the grid is not totalled or the field cannot be totalled (e.g. FX Mixed)

Can be tested with the IsNull() method

Grid Navigator Component

Property: Grid (String)

The ListGrid name that the totalling will be for

Property: Visible Button: ebTotal

Set true will enable the calculate totals button on the grid

How to use:

• Available for List Grid Component

• Can be a table component or a Memory Table component

• Must set the list grid component's property of Allow Totals = True

• Must set the "Grid" property of the grid navigator to be the grid it is pointing to

• Must enable the ebTotal = true button on the visible buttons of the grid navigator