Reporting occupancy by # campers on site |
Top Previous Next |
Q: I need to know how many paid campers I have each day. This means campers, not how many sites are filled or how much money I collected during the week.
It sounds like what you need is an Occupancy report that reports by # of people instead of # of reservations. There isn't a built-in report for this (because the fields that count the number of people are re-definable), but there's a sample Query that does this if you still use the default # Adults and # Children fields.
1. Go to Maintenance / Advanced Customizations / Queries, and click Import query.
2. Locate the folder C:\Program Files (x86)\Campground Master\Samples. (In the "Look In" drop-down at the top, start by clicking on the C: drive, then double-click the Program Files folder, etc. until you reach the Samples folder.)
Select the file "Sample Query - Occupancy (# people) by reservation type.csv" and Open it. That will add the query to the list. There's also another version, "Sample Query - Occupancy (# people) by site type.csv", that you can also add. Close the Query Setup dialog, and now you'll see a Query tab, between the Payments Due tab and the Transactions tab. Click on that, and select the above query from the drop-down list. Then just put in the date range needed.