select FirstName, Lastname, Belt, Age, Sex, Instructor, PaymentMethod, PayStatus, DateCreated as RegistrationDate from register where eventname = '#request.event_code#' order by Lastname, firstname

Payment Status Report

Registrants Sorted by Last Name

Last Name First Name Belt Age Sex Instructor Pmt Method Pmt Status
#LastName# #FirstName# #Belt# #Age# #Sex# #Instructor# #PaymentMethod# #PayStatus#