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.

 

 


Page URL https://CampgroundMaster.com/news/reportingoccupancybycampe.html

Campground Master Home