|Available in: Logi Info|| Source code name: SqlGroup|
ActiveSQL SqlGroup groups rows from a DataLayer, and allows aggregate values to be created. For example, suppose you have an Orders Table and you would like to list only the individual sales person associated with the orders. You would select something like EmployeeID as the grouping column. If you want to get a count of all orders for each employee, you would add a Group Aggregate Column with the function "COUNT". Alternatively, a "SUM" aggregate could provide the total sales for each employee.
Rows are grouped by values based on one or more columns of the DataLayer. Enter the grouping column name(s) in the GroupColumn attribute. Separate multiple column names with commas.
The Group can either keep just the first row from each group, or it can keep all groups. See the KeepGroupedRows attribute.
Element Group:Organize Data