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:
dw_control.Object.olecontrolname.GroupBy
Describe and Modify argument:
"olecontrolname.GroupBy { = ' columnlist ' }"
|
Parameter |
Description |
|---|---|
|
olecontrolname |
The name of the OLE Object control for which you want to get or set the grouping columns. |
|
columnlist |
(exp) A list of the columns or expressions that control the grouping. If there is more than one, separate them with commas. Columnlist can be a quoted DataWindow expression. |
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
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'")