The Categories table in the sample database contained an extra header to group and sort all products under categories specified in the database. We will explore how to make a separate header later in this lesson; for now we will learn how to group and sort the city names in the list. Let’s examine our simple customer list we created earlier in this lesson.

 

 

Let’s categorize the different customers based on the cities where they are located. First, click the Sorting and Grouping button () on the Report Design toolbar:

 

 

The Sorting and Grouping window will appear. Here you can specify which field you would like to use as the grouping level and how you would like to sort the group. In our case, we would like to group by city in ascending order, so choose City from the Field/Expression column and Ascending from the Sort Order column:

 

 

Close the Sorting and Grouping window, and then view the form in Form View. Though most of the customers are unique to their own cities, if you scroll to page six you will see the customers in Lisboa and London grouped together: