When I wrote this document, there was no way to just look up the information in the tutorial documentation (or anything else) on the Aristocrat website.
Mailing Address construction:
First Line:
{CDS_ACCOUNT.Address1a}
Second Line:
{CDS_ACCOUNT.City1} + ', ' + {CDS_ACCOUNT.State1} + ' ' + {CDS_ACCOUNT.Zip1}
Printing a Name:
First M. Last (with middle initial only if given)
{CDS_PLAYER.FirstName} + ( if {CDS_PLAYER.MiddleInitial} <> "" then ' ' + {CDS_PLAYER.MiddleInitial} + '. ' else ' ' ) + {CDS_PLAYER.LastName}
Last, First M. (middle initial only if given)
{CDS_PLAYER.LastName} + ', ' + {CDS_PLAYER.FirstName} + ( if {CDS_PLAYER.MiddleInitial} <> "" then ' ' + {CDS_PLAYER.MiddleInitial} else '' )
Title First M. Last Suffix, with title, MI, and suffix only if given
( if {CDS_PLAYER.Title} <> "" then {CDS_PLAYER.Title} + " " else "" ) + {CDS_PLAYER.FirstName} + ( if {CDS_PLAYER.MiddleInitial} <> "" then " " + {CDS_PLAYER.MiddleInitial} + ". " else " " ) + {CDS_PLAYER.LastName} + ( if {CDS_PLAYER.NameSuffix} <> "" then " " + {CDS_PLAYER.NameSuffix} else "" )
If you want the name to come out cleanly even if it has odd capitalization you can wrap the whole formula in the ProperCase() function.
Lifetime Actual Win by Player
{CDS_STATSUMMARY.cashin} - {CDS_STATSUMMARY.cashout} - {CDS_STATSUMMARY.jackpot}
The document says to use CDS_STATTABLE, which is not present in our version of OASIS.
Player Point Balance
{CDS_STATSUMMARY.ptsearned} + {CDS_STATBALANCE.ptsbalanceforward} + {CDS_STATBALANCE.ptsmgradjusted} + {CDS_STATBALANCE.ptspromoadjusted} - {CDS_STATBALANCE.ptsredeemed}
Making a date look like a date
ToText(DTSToDateTime({Field}), 'M/d/yyyy h:mm tt')
Alternatively, you could write a function whose output was the date, datetime, etc field, and then use Crystal's field format option to change the way it looks, then drag it into a text field where you want to display it. Do whatever's easier.