GroupBy

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

Example 1

ls_data = dw1.Object.ole_report.GroupBy

dw1.Object.ole_report.GroupBy = "emp_state, emp_office"

Example 2

dw1.Object.ole_report.GroupBy = "year"

ls_data = dw1.Describe("ole_report.GroupBy")

Example 3

dw1.Modify("  &

	ole_report.GroupBy='emp_state, emp_office'")

dw1.Modify("ole_report.GroupBy='year'")