Skip Headers
Oracle® Fusion Middleware Publishing Reports to the Web with Oracle Reports Services
11g Release 1 (11.1.1)

Part Number B32121-06
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

9.7 Running a Unicode Report using TTF/TTC Fonts

Oracle Reports 11g Release 1 (11.1.1) uses the new font mechanism to run a Unicode report on UNIX using the TTF / TTC fonts, generating report output that in most cases looks identical on both platforms.

Run a sample Unicode report on Windows:

  1. In Oracle Enterprise Manager, select Reports > Administration > Forms/Reports Common Configuration to display the Forms Reports Common Component Configuration Page.

    • Add the following entry under the [PDF:Subsetting] section:

      "Arial Unicode MS"="ARIALUNI.TTF"
      
    • Ensure there is no aliasing defined for Arial in the Global section. If there is, comment it out:

      #Arial=Helvetica
      
  2. Add the font ARIALUNI.TTF to REPORTS_PATH.

  3. Set NLS_LANG in the Windows registry to AMERICAN_AMERICA.UTF8.

  4. Open the sample report in Reports Builder.

  5. Select File > Generate to File > PDF.

  6. Save the report output.

Run the same Unicode report on UNIX:

  1. Check whether the Unicode font used by the report is already available on the UNIX server machine in $ORACLE_INSTANCE/reports/fonts and in the REPORTS_PATH (for example, ARIALUNI.TTF). If it is not available, copy it from the Windows machine to $ORACLE_INSTANCE/reports/fonts.

  2. Set NLS_LANG in reports.sh to AMERICAN_AMERICA.UTF8.

  3. Run the report using the following command line:

    http://host:port/report=report_name.rdf&destype=cache&desformat=pdf&userid=user/password@db
    

    For example:

    http://host:port/report=Unicode.rdf&destype=cache&desformat=pdf&P_LANG_ID=JA&userid=oe/oe@mydb
    

Compare the output on UNIX with that on Windows to confirm that they are identical.