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
Hotel
AGR/Room
Rooms
Services
$AGR
%AGR
%Total
%BR
181
BA Internet
104.65
70.50
3.87
181
BA Movies
43.8
29.50
2.21
181
BA Adult
0
0.00
0.00
VDA
0.82
Total
148.45
24.31
411
AA Internet
204.25
45.66
3.32
411
AA Movies
153.3
34.27
3.41
411
AA Adutl
89.75
20.06
1.46
VDP
1.09
Total
447.3
73.24
VPG
1.03
592
TOTAL
610.7
100