GroupBy DataWindow object property
Description
A comma-separated list of the columns or expressions that
control the grouping of the data transferred from the DataWindow
to the OLE object. When there is more than one grouping column,
the first one is the primary group and the columns that follow are
nested groups.
Controls
OLE Object controls
Syntax
PowerBuilder dot notation:
|
1 |
<span>dw_control</span>.Object.<span>olecontrolname</span>.GroupBy |
Describe and Modify argument:
|
1 |
"<span>olecontrolname</span>.GroupBy { = '<span> columnlist </span>' }" |
|
Parameter |
Description |
|---|---|
|
olecontrolname |
The name of the OLE Object control for |
|
columnlist |
(exp) A list of |
Usage
Target and Range also affect the data that is transferred
to the OLE object.
In the painter
Select the control and set the value in the Properties view,
Data tab, Group By option.
Examples
|
1 |
ls_data = dw1.Object.ole_report.GroupBy |
|
1 |
dw1.Object.ole_report.GroupBy = "emp_state, emp_office" |
|
1 |
dw1.Object.ole_report.GroupBy = "year" |
|
1 |
ls_data = dw1.Describe("ole_report.GroupBy") |
|
1 |
dw1.Modify(" & |
|
1 |
ole_report.GroupBy='emp_state, emp_office'") |
|
1 |
dw1.Modify("ole_report.GroupBy='year'") |