Adding accounting conventions to a report

As a way of supporting the conventions used in the accounting profession, Seagate Crystal Reports lets you decide on how to display the currency symbol, negative values, and zero values on your financial reports. You can also set up your report to reverse the signs for credit and debit amounts.

To add accounting conventions to a report

1. Right-click the currency field or number field you want to format to bring up the shortcut menu.
2. On the shortcut menu, click Format Field.

   The Format Editor dialog box appears with the Number tab open.

   

3. In the Style area, select how you want the system number format to appear for either positive or negative values.
4. In the Currency Symbol (system default) area, specify how you want the currency symbol to appear with the values on your report.
5. Click OK to save your changes.

To customize the accounting conventions for a report

1. Right-click the currency field or number field you want to format to bring up the shortcut menu.
2. On the shortcut menu, click Format Field.

   The Format Editor dialog box appears with the Number tab open.

3. In the Style area, select Custom Style, then click the Customize button.

   The Custom Style dialog box appears with the Number tab open.

   

4. Select the Use Accounting Format check box.

   Once you select this option, the following conditions occur:

   • In the Negatives list, how the negative values appear on your report are determined by the Windows locale settings. The negative values are represented by either a minus sign or brackets.
   • In the Show Zero Values as list, the dash symbol is automatically selected to represent zero values on your report.
   • On the Currency Symbol tab of the Custom Style dialog box, the currency symbol is positioned on the left-side of the currency and numeric values.

     Note:    Changes made to the Windows locale settings are implemented only after you exit and restart Seagate Crystal Reports.

5. Select the Reverse Sign for Display check box to reverse the signs for debit and credit amounts in your financial reports.
6. Click OK to save your changes.
7. Click OK again to return to your report.