Grouping in DataWindow

Grouped DataWindow objects can be created in two ways:

  • Use the Group presentation style to create a grouped DataWindow object from scratch.

  • Take an existing DataWindow object and define grouping.

Table 209. 

Group bands

Supported

Group Header band & Group Trailer band

Unsupported

None

Group bands options in the PowerBuilder painter

Supported

Color

Height

Group Definition

Reset Page Count

New Page on Group Break

Autosize Height*

Group Sort*

 

Group Sort

  • If a DataWindow contains multiple groups and more than one group is specified with sort criterion in the Group Sort option, the criterion of the group with the largest group band ID will be valid for all the groups on mobile, while the other criteria will be ignored.

  • It is only support to use aggregate functions in Group sort.

Autosize Height

  • The Autosize Height option is unsupported in Group Header and Group Trailer bands.

Unsupported

None

Properties for the Group keyword

Supported

New page

SyntaxFromSQL:

Group (colnum1, colnum2 NewPage)

ResetPageCount

SyntaxFromSQL:

Group(col1 {col2...}... ResetPageCount)

Unsupported

None

DataWindow functions for grouping

Supported

Groupcalc*

FindGroupChange

Groupcalc

In mobile applications, the Groupcalc function will be executed automatically when values in a group are changed by dot notation or SetItem method.

DataWindow expressions for grouping

Supported

Last

First

Percent

CumulativeSum

CumulativePercent

 

Unsupported

Large

Median

Mode

Small

Stdev

Stdevp

Var

Varp