Crystal Reports: Rules of Aristocrat OASIS Reports

Rules for Player Reports

(Adapted from Beginning Crystal Reports v.6.0 Guidebook, Aristocrat Technologies, 2002.)

1. For Mailing Reports, Create and Activate the Bad Address and Want Mail parameters.
2. All reports that contain statistics need to have IDType equal to 'P' for player reports, and 'G' for group reports.
3. To segment 'PIT' and 'SLOT' play, use the select expert to have Stattype equal to 'PIT' or 'SLOT'.
4. Always link Player_ID to Meta_ID for player-based reports, and Group_ID to Meta_ID for group-based reports. (The guidebook says to do this for group-based reports that use temporary cards.)
5. When creating player reports it is always recommended to group by Player_ID.
6. Insert and activate the Start and End Date parameters using the gaming date field in the stat table for reports with statistics.

Rules for Accounting Reports

(Adapted from Advanced Crystal Reports v.6.0 Guidebook, Aristocrat Technologies, 2002.)

1. The Audit Date parameter is equal to {?AuditDate}.
2. The ACTIVE field is equal to 'Y' if you want active machines.
3. The PERIOD_ID is equal to '4' (Current) or select another period_id based upon the type of report you are creating.
4. Link CDS_SLOTMAST to BB_REVISIONHISTORY by SLOTMAST_ID and REVISION.
5. Link BB_REVISIONHISTORY to BB_REVENUE by SLOTMAST_ID and AUDITDATE.

PERIOD_ID