Saturday, July 4, 2015

Generate Oracle Arabic Report 10g - PDF

Generate Oracle Arabic Report 10g - PDF Format




In the name of Allah, Most Gracious, Most Merciful
Praise be to Allah, blessing and peace be upon our prophet Mohammed, his family and his companions. After that,


: Key Problem

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


  
 Key Solution:
  

You have to set your report language to "Arial" Font not any other font, if the report displays rubbish data.


If your report displays data in question marks???, then you must  modify your  nls_lang.


Note:

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. 


    
  1. Set your NLS_LANG = ARABIC_EGYPT.AR8MSWIN1256
      
 or AMERICAN_AMERICA.AR8MSWIN1256
       or ARABIC_SAUDI ARABIA.AR8MSWIN1256     
       Or ARABIC_United Arab Emirates.AR8MSWIN1256
 
2. Set REPORTS_PATH to the system font directory such as C:\WINDOWS\Fonts
3. Open uifont.ali font file under D:\DevSuiteHome_2\tools\common , set the font alias entries at 
 
[PDF:Subset] section.
 
   The following font names are what you have to use in your report.
 
   [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"

NOTE: u can set any other Font name other than Traditional.ttf
 
4. Run the report with DESTYPE=FILE and DESFORMAT=PDF
 
           

Pls check the following link For more details of Font Sub-mask




Hope this helps…

My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.