Operation Manual

Cross-Tab Objects
Working with Cross-Tabs
17
Crystal Reports User’s Guide 343
Abbreviating large summarized fields
Because the values in a Cross-Tab’s summarized fields are often very large,
Crystal Reports lets you abbreviate such values.
Note: To complete this procedure, the report you’re working with must
include the custom function called
cdFormatCurrencyUsingScaling. The
sample report called
Custom Functions.rpt includes this function. Sample
reports are located in the Crystal Reports directory under
\Samples\En\Reports.
1. Right-click the summarized field you want to abbreviate and choose
Format Field from the shortcut menu.
The Format Editor appears.
2. On the Common tab, click the conditional formatting button adjacent to
Display String.
3. In the Functions tree of the Format Formula Editor, select
cdFormatCurrencyUsingScaling from the Custom Functions folder.
4. Complete the custom function’s arguments as follows:
cdFormatCurrencyUsingScaling
(CurrentFieldValue,1,"K","M")
• As the first argument, choose CurrentFieldValue from the
Formatting Functions folder of the Functions tree. This argument
defines the actual value to be summarized.
• As the second argument, enter the number of decimal places you
want to display on your Cross-Tab.
• As the third and fourth arguments, enter the strings (surrounded by
quotation marks) that you want to display as thousands and millions
symbols.
5. Click Check to identify any errors in the formula.
6. Fix any syntax errors the Formula Checker identifies.
7. When the formula has the correct syntax, click Save and close on the
Formula Workshop toolbar.
You return to the Format Editor dialog box.
8. Click OK to return to your Cross-Tab.
Your summarized field values appear abbreviated as defined.