اخواني الاعزاء السلام عليكم ورحمة الله وبركاتة
اخواني في عندي مشكلة الحروف العربية حيث تطلع مشفر عند الاستدعاء اي ان عند استخدم هذا الامر في الاستدعاء
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'pdf');
وانا اضطريت استخدم هذا من اجل التنسيقات مثل المربعات
واذا استخدمتو هذا
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,htmlcss');
يطلع التقرير عربي لكن مشكلة الاشكال
------------------------------------------
المطلوب حل لمشكلة العربي في pdf
طبعا المواضيع كثيرة ولكن لم اصل الى نتيجة ارجو منكم التعاون وجزاكم الله عنا الف الف خير

اقدم لكم الحل الجذرى لمشكلة الحروف العربي في هيئة pdf و للأمانة كل محتوى هذا الموضوع منقول من موقع METALINK

أولا : بالنسبه ل Oracle 9i/10g

QUOTE

Doc ID: Note:303862.1
Subject: Unable To Display Arabic in Reports Pdf Format In Oracle 9i/10g Reports Services
Type: PROBLEM
Status: MODERATED
Content Type: TEXT/X-HTML
Creation Date: 06-APR-2005
Last Revision Date: 07-JUL-2005


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.



The information in this document applies to:
Oracle Reports Developer - Version: 9.0.2 to 9.0.4
This problem can occur on any platform.

Symptoms
Issues with fonts when Arabic used,
Specific Arabic setup required


Cause
Extra setup required for Arabic need to be done, defining more fonts and removing some.
When Arabic is used, since Arabic and AR8MSWIN1256 do not exit on UNIX the font would be mapped to Symbol font.

Solution
.
To implement the solution, please execute the following steps:

1- If REPORTS_DEFAULT_DISPLAY=Yes; or not set (Default is yes)- Make sure the file $ORACLE_HOME/guicommon9/tk90/admin/uiscreenprint.txt has the following entry:

SCREENPRINTER:PostScript:1:Printer that mimics Display:screenprinter.ppd:

B. REPORTS_DEFAULT_DISPLAY=No then Make sure the file $ORACLE_HOME/guicommon9/tk90/admin/uiprint.txt has a printer defined. If not please add the following line to it

dummy:PostScript:2:dummy printer for PDF output:default.ppd:

Add the following to reports.sh

TK_PRINTER=dummy; export TK_PRINTER
TK_PRINT_STATUS='echo %n is valid'; export TK_PRINT_STATUS

2-A. If REPORTS_DEFAULT_DISPLAY=Yes is set then backup $ORACLE_HOME/guicommon9/tk90/admin/PPD/screenprinter.ppd file and edit it as in step C.

B. If REPORTS_DEFAULT_DISPLAY=No then backup $ORACLE_HOME/guicommon9/tk90/admin/PPD/datap462.ppd and edit it as in step C

C. Modify the fonts section
*DefaultFont: Courier
*Font AvantGarde-Book: Standard "(001.006S)" Standard ROM
*Font AvantGarde-BookOblique: Standard "(001.006S)" Standard ROM
*Font AvantGarde-Demi: Standard "(001.007S)" Standard ROM
*Font AvantGarde-DemiOblique: Standard "(001.007S)" Standard ROM
*Font Bookman-Demi: Standard "(001.003S)" Standard ROM
*Font Bookman-DemiItalic: Standard "(001.003S)" Standard ROM
*Font Bookman-Light: Standard "(001.003S)" Standard ROM
*Font Bookman-LightItalic: Standard "(001.003S)" Standard ROM
*Font Courier: Standard "(002.004S)" Standard ROM
*Font Courier-Bold: Standard "(002.004S)" Standard ROM
*Font Courier-BoldOblique: Standard "(002.004S)" Standard ROM
*Font Courier-Oblique: Standard "(002.004S)" Standard ROM
*Font Helvetica: Standard "(001.006S)" Standard ROM
*Font Helvetica-Bold: Standard "(001.007S)" Standard ROM
*Font Helvetica-BoldOblique: Standard "(001.007S)" Standard ROM
*Font Helvetica-Narrow: Standard "(001.006S)" Standard ROM
*Font Helvetica-Narrow-Bold: Standard "(001.007S)" Standard ROM
*Font Helvetica-Narrow-BoldOblique: Standard "(001.007S)" Standard ROM
*Font Helvetica-Narrow-Oblique: Standard "(001.006S)" Standard ROM
*Font Helvetica-Oblique: Standard "(001.006S)" Standard ROM
*Font NewCenturySchlbk-Bold: Standard "(001.009S)" Standard ROM
*Font NewCenturySchlbk-BoldItalic: Standard "(001.007S)" Standard ROM
*Font NewCenturySchlbk-Italic: Standard "(001.006S)" Standard ROM
*Font NewCenturySchlbk-Roman: Standard "(001.007S)" Standard ROM
*Font Palatino-Bold: Standard "(001.005S)" Standard ROM
*Font Palatino-BoldItalic: Standard "(001.005S)" Standard ROM
*Font Palatino-Italic: Standard "(001.005S)" Standard ROM
*Font Palatino-Roman: Standard "(001.005S)" Standard ROM
*Font Symbol: Special "(001.007S)" Special ROM
*Font Times-Bold: Standard "(001.007S)" Standard ROM
*Font Times-BoldItalic: Standard "(001.009S)" Standard ROM
*Font Times-Italic: Standard "(001.007S)" Standard ROM
*Font Times-Roman: Standard "(001.007S)" Standard ROM
*Font ZapfChancery-MediumItalic: Standard "(001.007S)" Standard ROM
*Font ZapfDingbats: Special "(001.004S)" Special ROM
*?FontQuery: "


To be like

*DefaultFont: Courier
*Font Arial: Standard "(001.004)" Standard ROM
*Font Arial-Italic: Standard "(001.004)" Standard ROM
*Font Arial-Bold: Standard "(001.004)" Standard ROM
*Font Arial-BoldItalic: Standard "(001.004)" Standard ROM
*Font Courier: Standard "(002.004S)" Standard ROM
*Font Courier-Bold: Standard "(002.004S)" Standard ROM
*Font Times-Bold: Standard "(001.007S)" Standard ROM
*Font Times-BoldItalic: Standard "(001.009S)" Standard ROM
*Font Times-Italic: Standard "(001.007S)" Standard ROM
*Font Times-Roman: Standard "(001.007S)" Standard ROM
*?FontQuery: "


2- Edit uifont.ali
1.
Comment
[ PDF ]
to be
# [ PDF ]

and

[ PDF:Embed ]
to
# [ PDF:Embed ]

2.
Replace
helvetica..Italic.Bold.. = "Arialbi.ttf"
helvetica...Bold.. = "Arialb.ttf"
helvetica..Italic... = "Ariali.ttf"
helvetica..... = "Arial.ttf"
Arial = "Arial.ttf"

with

Arial..Italic.Bold.. = "Arialbi.ttf"
Arial...Bold.. = "Arialbd.ttf"
Arial..Italic... = "Ariali.ttf"
Arial..... = "Arial.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- Make sure Arial AFM files are available in $ORACLE_HOME/guicommon9/tk90/admin/AFM directory.

For more information, refer to Note 229122.1 \How to Use AFM Files to Prevent Misaligned Reports Output due to Font Mapping *


4. Add the following line to reports.sh
DEBUG_SLFIND=/tmp/reports.log export DEBUG_SLFIND
Please note this line to be removed once everything works OK.

The reports.log will contain all Fonts required file and show you if there is any missing file.

5- Restart Reports Server and opmn

6- Extra fonts to be used has to be added to the ppd file, and related AFM
files placed in the AFM directory:
Reference:
Note 229122.1 \How to Use AFM Files to Prevent Misaligned Reports Output due to
Font Mapping *

*Please use the following option when generating AFM files from Arabic TTF files with ttf2pt1 utility

ttf2pt1 -l plane+0x06

and As TTF files used are Windows NLS_LANG for Reports to use Arabic PDF Susbseting AR8MSWIN1256






References
Note 229122.1 - How to Use AFM Files to Prevent Misaligned Reports Output due to Font Mapping

Keywords

'REPORTS.SH' 'AR8MSWIN1256'

ولكن يوجد جزء مهم جدا فى خانة regedit
REPORTS_PATH = ;c:\\windows\fonts تحدد موقع الخطوط فى الويندوز
فى الملف UIFONTS.ALI فى المسار dev10g\tools\common90
عدل فى الجزء التالي [ PDF:Subset ] اسف او اكتب البيانات التالية
"Arabic Transparent"..Italic.Bold.. = "ArialBI.ttf"
"Arabic Transparent"...Bold.. = "ArialBD.ttf"
"Arabic Transparent"..Italic... = "Ariali.ttf"
"Arabic Transparent"..... = "Arial.ttf"
فى حالة اذا كان الخط التقرير العربي من نوع Arabic Transparent\
مع المراعاه اللالتزام بكل شئ مكتوب واذا اردت تغيير انوع الخط العربي غير فقط اسم الخط
وبصراحة انا ىلا اعرف فى الاعلى ما هذا المكتوب لان هذه هى الطريقى الوحدية
وشكرا

يا اخ بشار لوكن تهت بسبب الكلام الكبير اللى فوق روح اللرابط ده
http://www.araboug.org/ib/index.php?showto...mp;#entry123715

السلام عليكم ورحمة الله وبركاتة
اخواني الاعزاء الف الف شكر لكم
الحمدلله انحلت المشكلة بفضل الله ثم بفضلكم جعله الله في ميزان حسناتكم

يا اخ بشار لوكن تهت بسبب الكلام الكبير اللى فوق روح اللرابط ده
http://www.araboug.org/ib/index.php?showto...mp;&do=findComment&comment=123715

ايضا ما زالت المشكله عملت كل ما في الخطوات ولا يم يعمل

ارجوا تثبيت الموضوع وايجاد حل له لانه مهم للغايه

اخي العزيز
لواتبعت هذا الخطوات تمام بيمشي معك وانا جربت على اكثر من جهاز
http://www.araboug.org/ib/index.php?showto...mp;&do=findComment&comment=123715
ويكون نوع الخط arabic transparent