Using the Currency Sheet

Use the Currency sheet of the Report Formats dialog to change the default report formats for currency fields.

To change the default report formats for currency fields

1. Click the Currency tab of the Report Formats dialog.

   The Currency sheet, shown in the following image, is then displayed.

   

2. The Use System Default check box is checked by default. If you make any changes to the controls on this dialog, the Use System Default check box automatically unchecks itself, indicating that the 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 this check box.

   To revert to the system default values at any time during the report design process, you can check the Use System Default check box.

   The Sample group box at the bottom of the sheet displays samples of the selected formats.

3. In the Positive list box, select how you want the currency symbol displayed in relation to the currency amount for a positive currency value.

   The default value of Leading Symbol indicates that the currency sign is printed to the left of the currency amount without an intervening space.

4. In the Negative list box, select how you want a negative currency amount displayed.

   The default value of Sign, Symbol, Number indicates that the negative sign is printed to the left of the currency symbol, which is printed to the left of the currency amount, and that there are no intervening spaces.

5. In the Currency Symbol text box, enter the currency symbol that you require.

   The default value is the standard dollar sign ($).

6. In the 1000's Separator text box, enter the character that you want to separate the thousands in your currency amount.

   The default value is a comma character (,). The maximum number of separator characters is three.

7. In the Decimal Separator text box, enter the character that you want to use to separate the whole numbers from the decimals in your currency amount.

   The default value is a period character (.). The maximum number of separator characters is three.

8. In the Decimals text box, enter the number (in the range 0 through 9) of decimal places that you want printed.

   The default value is 2.

9. To suppress the printing of zero (0) in front of the decimal point when the currency amount is less than 1, uncheck the Show Leading Zero for Decimals check box.

   By default, leading zeros are printed with currency amounts of less than 1.

10. Click another tab if you want to make changes on other sheets of the Report Formats dialog.

11. 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, you must 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.