Arabic Font Issue with PDF Report. Generate Oracle Arabic Report 10g – PDF Format . Report in Arabic(pdf)

Posted by & filed under .

Questions:

Generating Oracle Arabic Reports – PDF results in Arabic words are displaying in different characters in form window.

Arabic Font Issue with PDF Report  or Generate Oracle Arabic Report 10g – PDF  Format . Report in Arabic(pdf)

Answer:

  1. You have to set your report language to “Arial” Font not any other font, if the report displays rubbish data. All fields which suppose to show in arabic text should be Arabic Font Type.
  2. You have three NLS_LANG is located in your windows registry in three different entries. One for Oracle database, the other for forms and the third is for reports. (If you are using Developer 9i or higher version only Developer home level. I have following  NLS_LANG = American_America.AR8MSWIN1256
  3. Set REPORTS_PATH to the system font directory such as C:\WINDOWS\Fonts
  4. Open this file C:\DSHome\tools\common\uifont.ali 

    Add this under [ Printer ], Should look like this

    [ Printer ]
    Arial = “arial.ttf”
    Arial..italic… = “ariali.ttf”
    Arial…Bold.. = “arialbd.ttf”
    Arial..italic.Bold.. = “arialbi.ttf”
    “Andale Duospace WT J” = “Aduoj.ttf”
    “Albany WT J”=”AlbanWTJ.ttf”
    “Arabic Transparent”=”artro.ttf”
    Add this under [ PDF:Subset ]
    Should look like this

    [ PDF:Subset ]
    Arial = “arial.ttf”
    Arial..italic… = “ariali.ttf”
    Arial…Bold.. = “arialbd.ttf”
    Arial..italic.Bold.. = “arialbi.ttf”
    “Andale Duospace WT J” = “Aduoj.ttf”
    “Albany WT J”=”AlbanWTJ.ttf”
    “Arabic Transparent”=”artro.ttf”

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *