Crystal Reports  

Number Tab (Custom Styles)

Use the Number tab to set detailed formatting options for number fields in your report.

Use Accounting Format
When you select this option:
  • the negative symbol used and its position is determined by the Windows Regional Settings (it will be either the minus sign or the brackets)
  • the dash will be automatically chosen for "Show Zero Values as" (zero values are automatically displayed as dashes ('-') in your report
  • the currency symbol is fixed on the left side
Suppress if Zero
When you select this check box, nothing is printed in a column of number field data if it the value is zero.
Decimals
When you are setting up a custom format for a number field object, use this list to set the Decimals property for that object. This option allows you to specify the number of decimal places you want to print. You can specify from 0 to 10 decimal places. When you choose the number of decimal places you want, the program changes the sample number at the bottom of the dialog box to show you the results of your selection.
Rounding
When you are setting up a custom format for a number field object, use this list to set the Rounding property for that object. This property allows you to specify the number of places you want to round to. When you choose the number of places you want, the program changes the sample number at the bottom of the dialog box to show you the results of your selection.
Negatives
When you are setting up a custom format for a number field object, this property enables you to specify the way you want negative values to appear. Your options are:
-1.23 Prints negative values with a leading minus sign (-100.00, -225.73, -1,000,000).
1.23- Prints negative values with a trailing minus sign (100.00-, 225.73-, 1,000,000.00-).
(1.23) Prints negative values in parentheses [ (100.00), (225.73), (1,000,000) ].

The program changes the sample number at the bottom of the dialog box to reflect the property you choose.

Reverse Sign for Display
You can reverse the sign for debit and credit amounts in financial reports by selecting this check box.
Allow Field Clipping
The Allow Field Clipping check box determines whether overflow field representation is enabled for the selected field(s).
  • Select this check box to disable overflow field representation. This means that if the value in the field is too large for the field, the value will be truncated.
  • Clear this check box to disallow field clipping and enable overflow field representation. With overflow field representation enabled, values that are too large for their fields will be represented by a string of # signs.
Decimal Separator
When you are setting up a custom format for a number field object, the Decimal box allows you to type in the character(s) you want to use as a decimal separator. The default is a decimal point (.). If you want to change the separator, replace the character in the edit box with the separator of your choice. The program modifies the sample number at the bottom of the dialog box as you type in your characters.
Note   The box does not expand as you type in your separation characters; you are limited to the number of characters the box will hold.
Thousands Separator
The Thousands separator property allows you to choose the way you want numbers over 999 to appear on your reports.
  • When you select the property (check mark), the program inserts a comma (,) or another separator of your choice as a thousands separator character for amounts over 999. Your numbers are printed like this: 1,000.00, 10,000.00, 999,000.00.
  • When you clear the property you deactivate the thousands separator character. Your numbers are printed like this: 1000.00, 10000.00, 999000.00.
Symbol
This box displays the current thousands separator. The default is a comma (,). If you would like to use a different thousands separator, type it in this box. The changes you make in this box do not apply unless you select the Thousands Separator check box.
Leading Zero
Leading Zero allows you to include a zero, if you wish, before the decimal point in decimal amounts less than one.
  • Select this property if you want the program to include a zero before the decimal point whenever you have a decimal amount less than one (0.001, 0.9999, 0.755).
  • Clear this property if you do not want the leading zero (.001, .999, .755).
Show Zero Values as
This list contains the options available for displaying values of zero (0) in the selected field.

See Also

Format Editor | Formatting Data | Formula Editor