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 (for example, Unicode.rdf in the sample reports directory):

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 (if running the sample Unicode.rdf, choose P_LANG_ID=JA).

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.