Constants / Fields

Google+ Pinterest LinkedIn Tumblr +

A variety of new constants have been added to both Crystal and Basic syntax. All these new constants start with the prefix “cr.” The following list gives you a flavor of the kinds of new constants available. These constants arc only listed in the function pane of the Formula Editor when they can be used— which is usually only when writing conditional formulas.

•   Paragraph formatting: cr Unitcrpreted Text, ci’RTFT cxt, cr HTMLTcxt

• _ Dates; cr Usc System, cr Sundaycr Monday, etc.Date formatting: crDayOfWeeklnParenthesis, crDayOfWeckln SquareBrackets

Font formatting (found under “FontStyles” in the Functions tree): crRegiiIar,crBold, crltalic, crBorderline. You can also use the font names available in the Function tree, such as Arial and Courier.

Mathematical value; crPi


Treat database fields the same for both Basic and Crystal syntax. Enclose fields in curly {French] braces. Follow the table name by a period and then the field name, as in [table name field name].

Simple Data Types

The following sections contain some simple data type notes that will help you learn Basic syntax, especially if you’re already familiar with Crystal syntax. Re­fer to these sections as a summary of die basics, comparing the two syntaxes,


Do not use commas or currency symbols in either syntax, for example, 20000,

•400, 73.35


Crystal Syntax. Add the dollar sign ($) or use the CCurQ function to convertnumbers to currency.

120000.  S-400,  173.35 or CCur(2000QJ. CCurMOO). CCur(/3.35)

Basic Syntax. Use the CCur() function only.


About Author

Leave A Reply