Summary+Fields

media type="youtube" key="SlBqz6mXlqc?rel=0" height="390" width="480"

Task
GoToGigs is an organisation that owns and manages a number of concert venues throughout Scotland.

Download this FileMaker Pro file

It contains 4 tables: Promoter (__**Promoter ID**__, PromoterName, PromoterPhone, CommissionRate) Band (__**BandName**__, NumberofMembers, YearFormed, PromoterID*) Venue (__**VenueName**__, VenueAddress, VenueCity, SeatingCapacity, HireCost) Gig (__**VenueName***__, **Date**, BandName*, CostPerTicket, TicketsSold)

Part 1
Produce a report layout which shows total number of tickets sales for each city.

Solution

Part 2
Produce a report layout which shows the total ticket sales revenue for each city (formatted as currency).

Solution

Part 3
Produce a report layout that shows which of the promoters has been arranging the most concerts.

Solution

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.

Solution