Summary+Fields+Solution+Part+4

Part 4
GoToGigs have decided that the report does not provide enough detail and have asked you to improve the information shown by displaying a breakdown of how often each promoter arranges gigs in each of the four cities.

1. In Define Database, create a new Summary Field called GigCount. This should be a Count of Date (this may have been done in part 3)

2. Create a new layout (no body)

3. Add New Part -> Sub Summary sorted by PromoterName(Leading)

4. Add PromoterName to this part

5. Add New Part -> Sub Summary sorted by VenueCity(Leading)

6. Add VenueCity and GigCount to this part

7. Add New Part -> Sub Summary sorted by PromoterName(Trailing)

8. Add GigCount to this part

5. Ensure records are sorted by: PromoterName and VenueCity

6. Click Preview Mode