GroupBy
property (DataWindow object)
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.
Applies to
OLE Object controls
Syntax
PowerBuilder dot notation:
|
1 |
dw_control.Object.olecontrolname.GroupBy |
Describe and Modify argument:
|
1 |
"olecontrolname.GroupBy { = ' columnlist ' }" |
|
Parameter |
Description |
|---|---|
|
olecontrolname |
The name of the OLE Object control for which you |
|
columnlist |
(exp) A list of the columns or expressions that |
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 2 3 4 5 6 7 |
ls_data = dw1.Object.ole_report.GroupBy dw1.Object.ole_report.GroupBy = "emp_state, emp_office" dw1.Object.ole_report.GroupBy = "year" ls_data = dw1.Describe("ole_report.GroupBy") dw1.Modify(" & ole_report.GroupBy='emp_state, emp_office'") dw1.Modify("ole_report.GroupBy='year'") |