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