I need a Crystal Reports writing specialist who can write reports very well. I have one database, with 3 database tables, and the possibility of adding more tables/databases.
I would like to have some simple averages, and summations reported, and automatically sent to me via email. Below is a description of the columns, and information I need.
Occupied Rooms (OR) = 638 (taken from the bottom of the sta file)
Occupancy = 98% (taken from the Sta file, Occupied rooms/total rooms which we use as 660 rooms x 100)
Avg Service Price = 13.27 (average of all the prices)
Total Buys (TB) = 46 (This is a count of Total Buys)
TB/OR = 7.2% (Total Buys (count of all services) / Occupied Rooms)
AGR/Room = $1.03 (The total of all services / all rooms in the hotel)
Column Definitions –
AGR – Adjusted Gross Receipts – Total of all services in a category
%AGR – Percentage of Service Revenue based on Hotel
%Total - Percent Total for each Hotel
%BR - Buy Rate – This is the Buy rate, The number (Count) of buys for a certain service / number of rooms in the Hotel x 100
AGR/Room - Actual Gross Receipts/Room The daily rate of all rooms – Take the Total the Hotel makes / number of rooms