Use the Number sheet of the Report Formats dialog to set the default formats for numeric fields.
To change the default report formats for numeric fields
Click the Number tab of the Report Formats dialog.
The Number sheet, shown in the following image, is then displayed.
The Use System Default check boxes are checked by default. The check box on the left applies to whole number formats and the check box on the right applies to decimal formats. If you make any changes to the controls on this dialog, the corresponding Use System Default check box automatically unchecks itself, indicating that system default values set by the JADE Report Writer Configuration application are no longer being used. Alternatively, to begin making your changes, you can manually uncheck these check boxes.
To revert to the system default values at any time during the report design process, you can check either or both of the Use System Default check boxes.
The Samples group box at the bottom of the sheet displays samples of the selected formats.
In the Negative list box (in the Default Whole Number Format group box or Default Decimal Number Format group box), select the format for printing negative numbers.
The default Leading Sign value indicates that the negative sign (-) is printed to the left of the whole number or decimal without an intervening space.
In the 1000's Separator text box (in the Default Whole Number Format group box or Default Decimal Number Format group box), enter the character that you want to separate thousands.
The default value is a comma character (,). The maximum number of separator characters is three.
In the Decimals Separator text box of the Default Decimal Number Format group box, enter the character that you want to separate the whole numbers from the decimals.
The default value is a period character (.). The maximum number of separator characters is three.
In the Decimals text box of the Default Decimal Number Format group box, enter the number (in the range 0 through 9) of decimal places you want printed.
The default value is 2.
To suppress the printing of zero (0) in front of the decimal point when the number is less than 1, uncheck the Show Leading Zero for Decimals check box of the Default Decimal Number Format group box.
By default, the Show Leading Zero for Decimals check box is checked.
To suppress the printing of a number or decimal if it is zero (0), check the Suppress If Zero check box (in the Default Whole Number Format group box or Default Decimal Number Format group box).
By default, the Suppress If Zero check box is unchecked, indicating that the number or decimal is printed if it is zero (0).
Click another tab if you want to make changes on other sheets of the Report Formats dialog.
Click the Apply button to apply the changes you have made or click the Close button to close the Report Formats dialog.
To save the recent changes when you close the dialog, click the Apply button immediately prior to closing the dialog.
To abandon any changes that you have made but not yet applied, do not click the Apply button immediately prior to clicking the Close button.