Query

The query and the section are intertwined. The query determines the fields available in the section by which fields are defined as the Display Columns. The query Order By determines how the data is ordered and these must be designated as the Column fields in the Group By section. Do not use the Group By feature of the query. The Filter Columns in the query determine which Columns in the Group By section have filters.