Encerrado

Crystal Reports Specialist

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

Habilidades: Processamento de dados, PHP, Pesquisa

Ver mais: crystal reports specialist, writing room, writing crystal reports, write reports, who makes crystal reports, the writing room, crystal reports writing, crystal reports service, crystal reports specialists, movies crystal reports, Writing reports, tb, specialist, one percent, need a column writing, database receipts, data specialist and, crystal, ba, adjusted, 204, hotel price database, adult room, description hotel writing, avg

Acerca do Empregador:
( 3 comentários ) tuckers town, Bermuda

ID do Projeto: #144136