OraFAQ Forum: Reports & Discoverer » Generate oracle report 11g to arabic PDF

Home » Developer & Programmer » Reports & Discoverer » Generate oracle report 11g to arabic PDF (win2008 server, report 11g,)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Generate oracle report 11g to arabic PDF [message #519620]

Mon, 15 August 2011 15:01

sakrora
Messages: 5
Registered: August 2011
Location: Dammam

Junior Member

Dear All,

i have problem when generate arabic pdf with oracle report 11g 11.1.1.3

i put C:\Windows\Fonts in REPORTS_PATH

im using NLS_LANG = ARABIC_UNITED ARAB EMIRATES.AR8MSWIN1256

windows server 2008 SP R2 interface is arabic
i make restart many times for the server
im using adobe acrobat arabic version

when generate from report builder display correctly

but from url run time give me rabbish data in text or filed data

please told me where is the problem?
Thanks

my uifonts.ali :-

#
# $Header: uifont.ali@@/main/2 \
# Checked in on Sun Feb 22 17:41:15 PST 1998 by hwang \
# Copyright (c) 1997, 1998 by Oracle Corporation. All Rights Reserved. \
# $ Copyr (c) 1995 Oracle
#
# Copyright (c) Oracle Corporation 1995, 1997, 1998.
# All Rights Reserved.

/* See readme.ali for usage instructions. */
/* MS Windows uifont.ali */

[ Global ]

"Terwinal 993"..... = "Terwinal 993".....we8iso8859p1

/* Convert JEUC to SJIS for all fonts */
.....jeuc = .....sjis

/* Mac Fonts */
"Avant Garde" = Arial
"New Century Schlbk" = "Times New Roman"
"New York" = "Times New Roman"
Bookman = "Times New Roman"

/* Motif fonts */

lucidatypewriter = "Courier New"
lucidabright = "Times New Roman"
fixed = "Courier New"

/* Cue card fonts */
cuecard = Arial.8.Plain.Medium.Normal
cuecardFixed = "Courier New"..Plain.Medium.Normal

[ Printer ]

Arial..Italic.Bold.. = "Arialbi.ttf"
Arial...Bold.. = "Arialbd.ttf"
Arial..Italic... = "Ariali.ttf"
Arial..... = "Arial.ttf"
"Courier New" = "COUR.TTF"
"Courier New Bold" = "COURBD.TTF"
"Courier New Bold Italic" = "COURBI.TTF"
"Courier New Italic" = "COURI.TTF"
"Traditional Arabic" = "trado.ttf"
"Traditional Arabic Bold" = "tradbdo.ttf"
"Simplified Arabic" = "trado.ttf"
"Simplified Arabic Bold" = "tradbdo.ttf"
"Simplified Arabic Fixed" = "trado.ttf"
"Times New Roman" = "TIMES.TTF"
"Times New Roman Bold" = "TIMESBD.TTF"
"Times New Roman Bold Italic" = "TIMESBI.TTF"
"Times New Roman Italic" = "TIMESI.TTF"
"SAdvI25f" = "SADVI254.TTF"
"Arabic Transparent" = "trado.ttf"
"Arabic Transparent Bold" = "tradbdo.ttf"
"Arabic Transparent Bold Italic" = "trado.ttf"
"Arabic Transparent Italic" = "trado.ttf"
"Andale Duospace WT J" = "Aduoj.ttf"
"Arabic Transparent"="artro.ttf"
"Andale Duospace WT J" = "Aduoj.ttf"
"Albany WT J"="AlbanWTJ.ttf"
"Arial Unicode MS"..... = "ARIALUNI.TTF"
"Free 3 of 9" = "FREE3OF9.pfm FREE3OF9.pfb"
SAdHC39a = "SAdHC39a.ttf"
tahoma...Bold.. = "tahomabd.ttf"
tahoma..... = "tahoma.ttf"

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

/* Motif fonts */
courier = "Courier New"
times = "Times New Roman"

[ Display ]

# Oracle Report PDF sections
# Three new sections have been added:
# [ PDF ] - Used for font aliasing and Multibyte language support
# [ PDF:Embed ] - Used for Type 1 font embedding
# [ PDF:Subset ] - Used for True Type Font subsetting

[ 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"

[ 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 = "Arial.ttf"
# The True Type font files must exist in any one of the folders specified in
# REPORTS_PATH.

Arial..Italic.Bold.. = "Arialbi.ttf"
Arial...Bold.. = "Arialbd.ttf"
Arial..Italic... = "Ariali.ttf"
Arial..... = "Arial.ttf"
"Courier New" = "COUR.TTF"
"Courier New Bold" = "COURBD.TTF"
"Courier New Bold Italic" = "COURBI.TTF"
"Courier New Italic" = "COURI.TTF"
"Traditional Arabic" = "trado.ttf"
"Traditional Arabic Bold" = "tradbdo.ttf"
"Simplified Arabic" = "trado.ttf"
"Simplified Arabic Bold" = "tradbdo.ttf"
"Simplified Arabic Fixed" = "trado.ttf"
"Times New Roman" = "TIMES.TTF"
"Times New Roman Bold" = "TIMESBD.TTF"
"Times New Roman Bold Italic" = "TIMESBI.TTF"
"Times New Roman Italic" = "TIMESI.TTF"
"SAdvI25f" = "SADVI254.TTF"
"Arabic Transparent" = "trado.ttf"
"Arabic Transparent Bold" = "tradbdo.ttf"
"Arabic Transparent Bold Italic" = "trado.ttf"
"Arabic Transparent Italic" = "trado.ttf"
"Andale Duospace WT J" = "Aduoj.ttf"
"Arabic Transparent"="artro.ttf"
"Andale Duospace WT J" = "Aduoj.ttf"
"Albany WT J"="AlbanWTJ.ttf"
"Arial Unicode MS"..... = "ARIALUNI.TTF"
"Free 3 of 9" = "FREE3OF9.pfm FREE3OF9.pfb"
SAdHC39a = "SAdHC39a.ttf"
tahoma...Bold.. = "tahomabd.ttf"
tahoma..... = "tahoma.ttf"

#
# Subsetting TrueType Collection fonts:
# Typically, a TTC font contains several fonts in one file. For example,
# the TTC file, msgothic.ttc consists of three fonts in the order
# MS Gothic, MS PGothic and MS UI Gothic. To subset MS PGothic, the
# entry in the PDF:Subset section of uifont.ali would be:
# "MS PGothic" = "msgothic.ttc,1"
#

# NOTES ON PRECEDENCE OF PDF SECTIONS:
# ------------------------------------
#
# If you have entries for a same font in many PDF sections, then Font
# Aliasing entry will take precedence over Font Subsetting entry. Entries
# in Font Subsetting will take precedence over the entries in Font Embedding
# section.
#
# Generic entries for a font must follow more specific entries for the same
# font. For instance, if you want to subset Arial Plain, Arial Bold,
# Arial Italic and Arial Bold-Italic fonts, your entries must be:
#

[rwbuilder]
.....AR8MSWIN1256="Courier New"
.....CL8MSWIN1251="Courier New"
.....EE8MSWIN1250="Courier New"
.....EL8MSWIN1253="Courier New"
.....IW8MSWIN1255="Courier New"
.....JA16SJIS="MS Gothic"
.....TH8TISASCII="Andale Duospace WT"
.....TR8MSWIN1254="Courier New"

Report message to a moderator

Re: Generate oracle report 11g to arabic PDF [message #519661 is a reply to message #519620]

Tue, 16 August 2011 03:55

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Please verify again these steps.


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"

Also read this.

Troubleshooting If font subsetting does not work, verify the following:
? In Acrobat Reader, click File > Document Properties > Fonts. Verify that the Actual Font value is Custom and Type is Type3. If this is not specified then fontsubsetting did not occur. The problem could be either that the fonts were not found or the entry in the uifont.ali file is incorrect.? The font file names are valid.? The font types are TrueType, i.e., filename.ttf/filename.ttc.? The font name is enclosed in double quotes if it consists of two or more words.? The font name does not contain embedded parenthesis.? The font files are located in the path specified by the REPORTS_PATH environment
variable. When generating a PDF file, Oracle Reports looks for fonts in the path specified in the REPORTS_PATH environment variable. ? The font names are correct and are available on the machine where the PDF file is generated.? The [PDF:Subset]section name in the uifont.ali file has not been modified.Oracle Reports parses the file looking for the section name.? The version of the Adobe Acrobat Reader used for viewing is version 3.0 or higher.This is the version required for multibyte character reports to display properly.? Fonts that are subset look bold. This is an issue with Type3 fonts, which are created during font subsetting. Type 3 fonts are imaged characters that look slightly bolder than they would if expressed as a Type 1 font. See Recommended for more information on improving the viewing quality.

Regards,
Irfan

Report message to a moderator

Re: Generate oracle report 11g to arabic PDF [message #519669 is a reply to message #519661]

Tue, 16 August 2011 04:38

aiyaz_ma
Messages: 56
Registered: May 2009
Location: Hyderabad

Member

Did you get solved this ?

Report message to a moderator

Re: Generate oracle report 11g to arabic PDF [message #519950 is a reply to message #519669]

Wed, 17 August 2011 12:27

sakrora
Messages: 5
Registered: August 2011
Location: Dammam

Junior Member

i tried agine and make restart, check reports_path in registry,

the same problem please open attached file.

the type is 1 not 3 with me

thanks.

Khalil Sakr

Attachment: arabicpdf.jpg
(Size: 90.21KB, Downloaded 3019 times)

Report message to a moderator

Re: Generate oracle report 11g to arabic PDF [message #519951 is a reply to message #519950]

Wed, 17 August 2011 12:29

sakrora
Messages: 5
Registered: August 2011
Location: Dammam

Junior Member

my uifont.ali attached(with change to .txt)

Attachment: uifont.ali.txt
(Size: 3.01KB, Downloaded 3568 times)

Report message to a moderator

Re: Generate oracle report 11g to arabic PDF [message #520073 is a reply to message #519620]

Thu, 18 August 2011 07:43

sakrora
Messages: 5
Registered: August 2011
Location: Dammam

Junior Member

i have win2008 server R2, oracle report 11g (11.1.1.3)
i have problem with arabic pdf data

Where do you set REPORTS_ENHANCED_SUBSET=NO

Thanks,
Khalil Sakr

Report message to a moderator

Re: Generate oracle report 11g to arabic PDF [message #520278 is a reply to message #520073]

Sat, 20 August 2011 04:31

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Did you Set font from Report menu toolbar Format -> Font - Aril
-> Script - Arabic .

Secondly Format -> Set Direction Right to Left.

Regards,
Irfan

Attachment: Arabic.PNG
(Size: 39.99KB, Downloaded 3293 times)

Report message to a moderator

Re: Generate oracle report 11g to arabic PDF [message #609585 is a reply to message #520278]

Mon, 10 March 2014 02:47

achafeez
Messages: 2
Registered: July 2013
Location: Riyadh, Saudi Arabia

Junior Member

where to set path................reports_enhanced_subset=yes
what is location of folder where i have to set this value....
or it has to set in the registry....in the registry thee is no variable like reports_enhanced_subset

Please guide me...

[Updated on: Mon, 10 March 2014 03:51]

Report message to a moderator

Previous Topic:	FRM-41214 : Unable to run report
Next Topic:	Oracle Reports 6i in PDF

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 17:18:32 CST 2025