First question is data from your query. Does it have 6 rows or did you show some grouping already?Yes, a query is already sorted by the field that will be used for grouping as in your example.
Is it possible that you write exact result set from your query and draw on paper how you want your report to look like and post photo?