Follow-On Topics

Related Topics

# About the Grouping Pane

The Grouping section is used to create a query that returns consolidated data and is commonly used in conjunction with aggregation functions such as `SUM` or `COUNT`.

By selecting certain columns within the Grouping section the data is consolidated so that no duplicates exist across the fields returned. In turn, the aggregate functions enable information such as totals or averages to be calculated across the records that are consolidated. The section corresponds directly with the `GROUP BY` clause in the SQL syntax.

There are three methods available for adding a column to the Grouping section:

1. Drag and drop the column from the OLEDB or ODBC Schema area
2. Double-click on the column in the OLEDB or ODBC Schema with the Grouping section selected.
3. Drag and drop the column from the Columns section if it has already been selected.

As further columns are added they are displayed to the right of the last column entered and this is the order in which they are grouped. Columns may be re-ordered by dragging and dropping them to the left or right of another column.

TIP:

For the vast majority of OLEDB or ODBC drivers, when using Grouping all non-aggregate Columns must be selected.

Right-clicking on a column displays the following options

|  | Remove — Removes the column from the Grouping section.

Copyright © 2018 Quadrant Software B.V. All rights reserved.