38.1 Prerequisites for This Example

To build the example in this chapter, you must have the example files we have provided (see "Example Scenario", above), as well as access to the Order Entry sample schema provided with the Oracle Database. If you do not know if you have access to this sample schema, contact your database administrator. You must also have Acrobat Reader installed on your system.

Note:

Due to some limitations of Oracle Reports regarding use of the UTF-8 character set and multibyte fonts on UNIX, it is recommended to build this report only on Windows. To deploy a multibyte report on UNIX, refer the chapter "Resolving Cross-Platform Porting Issues" in the Oracle Fusion Middleware Publishing Reports to the Web with Oracle Reports Services manual.

Perform the following set up activities before you run the report:

  1. In the Windows registry, under KEY_OH in the ORACLE key, set NLS_LANG to AMERICAN_AMERICA.UTF8.

    Tip:

    Back up your registry before editing it as working with registry keys can cause the system to become unstable.
  2. Open the uifont.ali file and edit it to specify the TrueType font file name. Type "Arial Unicode MS" = "ARIALUNI.TTF" under the [PDF:Subset] section. After including the line, the uifont.ali file should look like:

    Figure 38-3 uifont.ali file edited to include the TrueType font file name

    Description of Figure 38-3 follows
    Description of "Figure 38-3 uifont.ali file edited to include the TrueType font file name"

    Note:

    On Windows and UNIX, the uifont.ali file is located in ORACLE_INSTANCE\config\FRCommonComponent\frcommon\guicommon\tk\admin. The uifont.ali file defines the font aliases used by Oracle Reports and is extremely useful for cross-platform development. This file enables you to define which fonts to substitute when a particular font is unavailable. For more information, see the "Font Related Features" section in the chapter "Using PDF in Oracle Reports" in the Oracle Fusion Middleware Publishing Reports to the Web with Oracle Reports Services manual.
  3. In the Windows registry under the Oracle key and IDS_HOME, add the location of the ARIALUNI.TTF TrueType font file to the value of REPORTS_PATH. For example, C:\WINNT\Fonts.

    Note:

    Install the TrueType font file ARIALUNI.TTF into C:\WINNT\Fonts, if it is not already there.