Article Details
Id:12528
Product:finPOWER Connect
Type:NEW
Version:2.02.04
Opened:19/12/2014
Closed:22/12/2014
Released:13/02/2015
Job: J014689

Page Sets; Grids; Groupings can now be added to Grids

Page Set Grids can now group by one or more columns.

A new GroupByColumns property has been added for Grids. This should be set when the Grid is first initialised and after the Grid's Columns have been defined.

Typically, you would only group by a single columns (as per the example below), however you can specify a comma-separated list of Column Keys to group by multiple columns.

NOTE: All groupings are shown in ascending (low to high) order.

With gridTest
  With .Columns
    .AddDrilldown("Drilldown", "")
    .AddString("AccountId", "Account", , True)
    .AddString("Name", "Name", , True)
  End With
  
  ' Group by Name
  .GroupByColumns = "AccountId"
End With