3.1 Custom Member Location Reservation Report
Problem
Our ice area is looking for a report/schedule (like attached) to send to customers renting and attaching to contracts to be paid. I am trying to modify some of the standard reports but not having much luck.
We want it to list:
- The Household making the reservation
- Date of reservation in chronological order, What is being reserved, Purpose, Start time, End time, Rate
- Subtotal on month
Solution
Created a custom output for Member Location Reservation Report. Sample report and XML file are attached.
NOTES:
- Report is designed to be run for a single Household at a time.
- Report will page on change in Facility Location.
- Report will sub-total the FeeAmt, Fee Paid, and Amt Due for each Reservation Number, Month, Patron, and a Grand Total.
- FeeAmt, FeePaid, and AmtDue on this report all exclude Deposit Fees & Payments.
SORTING:
- Report Sorts by SADetail.PatronLinkID (Individual Person; not Household), by SAPerson_NameFirstLast, by FRFacility_FacilityLocation, by SADetail_BeginDate-MonthInt (sorts reservation by month in chronological order), by SADetail_BeginDate-MonthChar (needed to print the character value of the month in the subtotal label), by SADetail_ReservationNumber, by SADetail_BeginDate.
SUMMARY TOTALS:
- Total Reservations gives the total number of unique reservations (uses SADetail_ReservationNumber).
See Attachment: KB__3006__Member_Location_Reservation_Report.pdf
See Attachment: KB__3006__Member_Location_Reservation_Report_502416.xml