We need a way to capture service hours worked for each member based on their attendance at events categorized as “service”, as shown in the sheet below. Your custom reports feature does not give us this ability.
member name patrol name event name date hours
Starr, Joseph Hawk/Panther Pack 199 Blue & Gold Banquet 2/23/16 2
Starr, Joseph Hawk/Panther Pinewood Derby Track Setup 4/8/16 2
Starr, Joseph Hawk/Panther Pack 199 Pinewood Derby 4/9/16 4
Gogel, Max Hawk/Panther Cemetery Cleanup 4/23/16 4
Starr, Joseph Hawk/Panther Cemetery Cleanup 4/23/16 4
Gogel, Max Hawk/Panther Cemetery Cleanup 10/29/16 4
Starr, Joseph Hawk/Panther Cemetery Cleanup 10/29/16 4
Gogel, Max Hawk/Panther M Packard Eagle Project workday 8/6/16 4
Gogel, Max Hawk/Panther M Gogel Eagle Project workday 8/2/16 5
Starr, Joseph Hawk/Panther M Gogel Eagle Project workday 8/2/16 5