Some databases require a Group By clause with certain functions. In SQR Production Reporting Studio, data grouping is generally linked to aggregate functions such as: AVG, COUNT, MIN, MAX, or SUM. These functions group the data returned by the query and produce summary values.
SQR Production Reporting Studio automatically generates the Group By statement needed by your query; however, you can override the default grouping if desired.
To manually configure the grouping:
Click Group By on Query Builder - Fields (see Selecting Fields).
In the Group By dialog box, clear Generate Group By statement automatically.
Select a column under Available Fields and add it to Group By Fields.
Note:
Do not confuse this grouping with the defined in the Group Breaks page in the Query Builder (see Creating Group Breaks.