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.
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
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.
3 comments :
What I liked more in this tutorial is the begining and the end :)
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,
...
My success only comes from Allah, pls. note your comments and suggestions are great help for me in progress thanks in advance.
Thank's Akhi..
Thanks Akhi, your comments are greatly appreciated.
Allah bless you, Ameen.
خطوات سهلة و اشتغلت تمام
تسلم ايديك
Post a Comment