NEW2.02.04 · Released 13 February 2015
NEWfinPOWER Connect
Released in
2.02.04
13 February 2015
  1. Opened19 Dec 2014
  2. Closed22 Dec 2014
  3. Released13 Feb
Article 12528 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