For a printable version of the Reporting topics, click here: http://ws4.insightdirect.com/Download/Website/docs/Crystal_Reports.pdf
Previous Topic: Creating Crystal Reports Formulas
If a Crystal Reports formula field results in a number that you want to display as currency (i.e., $1,235.99), you must cast this number as currency in order to ensure that it is correctly displayed. This step is essential because Crystal Reports may read a field with a monetary amount NOT cast as currency as a simple (non-currency) number, omitting the partial values (decimal values) from the amount.
To cast a number as currency, use one of the following arguments:
CCur (number)
CCur (string)
For example:
' Forces the rate field to a CURRENCY value so
Crystal will apply correct international formatting.
formula = CCUR ({WorkOrderItems.Rate})
Next Topic: Running Totals Overview
Back to Reports Table of Contents