Home » Developer & Programmer » Reports & Discoverer » Report in Arabic(pdf) (Oracle 10g Reports, Windows 2003 server)
Report in Arabic(pdf) [message #478120] Wed, 06 October 2010 07:24 Go to next message
deepakmannazhi
Messages: 137
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear all,
We Implemented Unicode facility in our application, in forms its working fine. But, while running report in pdf arabic Characters are not displaying Properly.

we did the following settings in uifont.ali
[ PDF:Subset ]
Arial..Italic.Bold.. = "Arialbi.ttf"
Arial...Bold.. = "Arialbd.ttf"
Arial..Italic... = "Ariali.ttf"
Arial..... = "Arial.ttf"
"Simplified Arabic"= "simpo.ttf"
"Arabic Transparent"="artro.ttf"
"Traditional Arabic"="trado.ttf"

c:/windows/fonts directry is added in REPORTS_PATH.

Pls help to solve this..

Thnkz and regards
Deepak
Re: Report in Arabic(pdf) (merged) [message #478137 is a reply to message #478120] Wed, 06 October 2010 09:13 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Please Also check these points.

1. Add C:\Windows\Fonts in REPORTS_PATH In Registry
2. Open this file C:\DSHome\tools\common\uifont.ali
3. 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"


4. 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"



Regards,

Irfan
Re: Report in Arabic(pdf) (merged) [message #478143 is a reply to message #478137] Wed, 06 October 2010 09:46 Go to previous messageGo to next message
deepakmannazhi
Messages: 137
Registered: February 2010
Location: Dubai, UAE
Senior Member

Dear Irfan,

I'm Extremely thankful to your kind reply, now its working fine. thanks... thanks a lot. I have another doubt,is the order of font specification in uifont has any relevance..?

Quote:
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"


Thanks and Regards
Deepak
Re: Report in Arabic(pdf) (merged) [message #478470 is a reply to message #478143] Sat, 09 October 2010 02:15 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear Deepak,
Thanks for the feedback.
Re: Report in Arabic(pdf) (merged) [message #641903 is a reply to message #478120] Thu, 27 August 2015 02:46 Go to previous message
syedraoof
Messages: 1
Registered: August 2011
Junior Member
Dear Irfan,

Assalam Alaikum..

I am also facing the same issue of arabic font while generating the oracle reports (it is showing as junk(like ????????)).

Even Facing problem on displaying barcode-font as well. It is working fine and displaying the barcode as well as arabic while running through report builder but when running via browser it shows the actual content (e.g. numbers instead of barcode and for arabic junk)

I followed this MDOC (Barcode Font Not Included in Reports PDF Output on Windows (Doc ID 602070.1)) even gone through this discussion note (entry in uifont.ali has no effect)

Treatment " :

Step 1 : Font Aliasing
Step 2 : Font Subsetting

For more details : https://metalink.oracle.com/

Note.350971.1 Troubleshooting Guide for Font Aliasing / Font Subsetting / Font Embedding Issues:


Following is the steps i followed.

1. Fonts installed (3 of 9 Barcode (True Type) and Arial (True Type)
1. Added the fonts location C:\Windows\Fonts in REPORTS_PATH In Registry as well as in Report_Server config file. (File attached fyr)
2. Below is the contents of uifont.ali file

[ Printer ]

/* Mac Fonts */
"Avant Garde" = "Avant Garde"
"New Century Schlbk" = "New Century Schoolbook"

Arial = "arial.ttf"
Arial..italic... = "ariali.ttf"
Arial...Bold.. = "arialbd.ttf"
Arial..italic.Bold.. = "arialbi.ttf"
"Arabic Transparent"="artro.ttf"

[ PDF ]

# This example shows how to rename Arial font to Courier font
# Arial = Courier
# You can Alias specific styles of font as below
# Arial.12..Bold.. = Courier.14....
# "Times New Roman".12..Bold = "Sans Serif"
#
# Support for Far Eastern Languages:
# ----------------------------------
# PDF section can be additionally used to enable Multibyte language support
# built into Reports. To use this feature with Adobe (r) Acrobat (c), you
# need to install the Asian font pack available online at the Adobe web site.
# By specifying the below aliasing, a Japanese report run with Shift-JIS
# characterset is replaced to HeiseiKakuGo-W5-Acro CID font.
# .....SJIS = "HeiseiKakuGo-W5-Acro"


"3 of 9 Barcode"..... = "3 of 9 Barcode"

[ PDF:Embed ]

# This example shows how to embed Type 1 Arial font into the PDF file:
# Arial = "Arial.pfm Arial.pfb"
# You need to specify the .pfm file before the .pfb file.
# The font files must exist in one of the folders specified in REPORTS_PATH.

[ PDF:Subset ]

# This example shows how to subset Arial True Type font into the PDF file
Arial..Italic.Bold.. = "Arialbi.ttf"
#Arial...Bold.. = "Arialbd.ttf"
Arial..Italic... = "Ariali.ttf"
Arial..... = "arial.ttf"
"Arabic Transparent"..Italic.Bold.. = "ARIALBI.TTF".....
"Arabic Transparent"..Italic... = "ARIALI.TTF".....
"Arabic Transparent"...Bold.. = "Arialbd.ttf"
"Arabic Transparent"..... = "artro.ttf"


Tahoma = "TAHOMA.ttf".....ar8mswin1256
#Arial = "Tahoma"
"Tahoma Bold" = "tahomabd.ttf"
Tahoma...Bold.. = "tohamabd.ttf"
Tahoma..... = "tohama.ttf"
"Simplified Arabic"="arial.ttf"
"Simplified Arabic"...Bold.. ="arial.ttf"
"Times New Roman"..Italic.Bold.. = "timesbi.ttf"
"Times New Roman"...Bold.. = "timesbd.ttf"
"Times New Roman"..Italic... = "timesi.ttf"
"Times New Roman"..... = "times.ttf"
"Courier New"..Italic.Bold.. = "courbi.ttf"
"Courier New"...Bold.. = "courbd.ttf"
"Courier New"..Italic... = "couri.ttf"
"Courier New"..... = "cour.ttf"
Courier..... = "cour.ttf"
Courier...Bold.. = "courbd.ttf"

"3 of 9 Barcode"..... = "bar1.TTF"


Bu still no success and On commenting (Arial..... = "arial.ttf") line in uifontali.file report is getting generated but with junk characters and on running the report by un-commenting it give me errot message as ( REP-1924: Cannot locate the font file 'arial.ttf' ).


Your valuable advises/assistance is highly appreciated.

Regards,
Syed
Previous Topic: Seeded Excel Report error ( European users only)
Next Topic: Reports hang in the queue
Goto Forum:
  


Current Time: Thu Mar 28 13:34:26 CDT 2024