Defining Currency Formats

Currency formats defined in the Administration Runtime Configuration page are applied at the system level. Currency formats can also be applied at the report level.

The report-level settings take precedence over the system-level settings here. For information on setting a report-level currency format, see Configuring Currency Formats in Report Designer's Guide for Oracle Business Intelligence Publisher.

Understanding Currency Formats

The Currency Formats tab enables you to map a number format mask to a specific currency so that your reports can display multiple currencies with their own corresponding formatting. Currency formatting is only supported for RTF and XSL-FO templates.

To apply these currency formats in the RTF template, use the format-currency function. See Formatting Currencies in Report Designer's Guide for Oracle Business Intelligence Publisher for detailed procedures.

To add a currency format:

1. Click the Add icon.
2. Enter the ISO currency code, for example: USD, JPY, EUR, GBP, INR.
3. Enter the format mask to apply for this currency.

   The Format Mask must be in the Oracle number format. The Oracle number format uses the components "9", "0", "D", and "G" to compose the format, for example: 9G999D00

   where

   9 represents a displayed number only if present in data

   G represents the group separator

   D represents the decimal separator

   0 represents an explicitly displayed number regardless of incoming data

   See Using the Oracle Format Mask in Report Designer's Guide for Oracle Business Intelligence Publisher for more information about these format mask components.

The figure below shows sample currency formats.

Description of the illustration GUID-85365DA9-0881-45DE-A96D-C85754C8BB27-default.gif