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 = [url removed, login to view] (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 = $[url removed, login to view] (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

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

181

BA Movies

43.8

[url removed, login to view]

[url removed, login to view]

181

BA Adult

0

[url removed, login to view]

[url removed, login to view]

VDA

[url removed, login to view]

Total

[url removed, login to view]

[url removed, login to view]

411

AA Internet

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

411

AA Movies

153.3

[url removed, login to view]

[url removed, login to view]

411

AA Adutl

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

VDP

[url removed, login to view]

Total

447.3

[url removed, login to view]

VPG

[url removed, login to view]

592

TOTAL

610.7

100

Habilidades: Processamento de dados, PHP, Pesquisa

Ver mais: crystal reports specialist, writing crystal reports, makes crystal reports, writing room, crystal reports writing, crystal reports service, crystal reports specialists, movies crystal reports, writing reports, tb, specialist, one percent, need column writing, database receipts, crystal, ba, adjusted, 204, hotel price database, description hotel writing, avg, email hotel database, simple hotel, rate crystal reports, write hotel description

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

ID do Projeto: #144136