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 241. 

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*

 

Height

When the Group Header is higher than the page, the header content will be printed into the footer area, and the content printed in the footer area will be printed again at the beginning of the next page. This is the behaviour on Web which is different from PowerBuilder.

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 the Web, 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 Web 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