Use the Number tab (click Customize on the Number tab of the Format Editor) to set detailed formatting options for number fields in the 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 the 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 the 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 the 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. the 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 leading minus sign (-100.00, -225.73, -1,000,000).


(1.23) Prints negative values in parentheses [ (100.00), (225.73), (1,000,000) ].


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


Reverse Sign for Displaying

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. For example, if you have a field that is sized to allow 5 characters, and the value in the field is 3708.19, the field will print the value: 3708.1 (assuming that the field values are right-justified).
  • 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. For example, if you have a field that is sized to allow 5 characters, and the value in the field is 3708.19, the field will print: #####. This lets you know that the field needs to be resized (or that you need to select the Can Grow property).

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 the choice. The program modifies the sample number at the bottom of the dialog box as you type in the characters.

 
    Note: The box does not expand as you type in the 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 the reports.

     
    • When you select the property (check mark), the program inserts a comma (,) or another separator of the choice as a thousands separator character for amounts over 999. the 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. the 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.