How to Define GROUP BY and ORDER BY clauses

Previous Next

To define GROUP BY or ORDER BY clauses:

1.Select the Group By Definitions or the Order by Definitions tab in the Select List Pane.
2.Drag-and-drop the column(s) that should appear in the GROUP BY or ORDER BY clause from the Repository on to the Select List.
3.Type numbers in the Position field to set/rearrange the ascending order of columns in the GROUP BY or ORDER BY clause.