Oracle Reports Font Standardization


We need to make our Oracle database and applications Unicode compliant. To do this we have decided to use the UTF8 character set. The NLS_LANG Oracle registry string can be set to use UTF8.
We have decided to use the Andale font. This means the data items in all our forms and reports need to be set to use the Andale font.
With Oracle Forms, a property class can be used but with Oracle Reports I'm not sure how this can be implemented so the font for all our pre-existing reports can be changed in one place. Oracle reports does not have property classes like Forms does. You can create a Reports template that can be selected from the Reports Wizard before the layout is generated but as far as I can tell that would require regenerating the layout for every report every time a font change is required. I don't want to do that I just want to have it changed from a reference like Forms has with the property class that can be inherited.
Do you know how Oracle Reports works in this regard? Is there a clean way to set up Oracle Reports so the font for all data items can be changed in one place or will I have to manually change it for every desired item in every report? There is also the possibility of creating a custom Oracle registry string for font and using that but I don't know if that is a good idea.


If Cyrillic or any other locale served by a single-byte font is the only requirement, then it is easier to achieve success. You can use UTF8 in your database, and use the appropriate single-byte character set in your Reports environment (e.g., Windows 1251 for Cyrillic). There are still issues that may need to be resolved - for example, Reports doesn't generate the corresponding IANA characterset marking at the beginning of the HTML file, nor put the specific codepage marking at the beginning of the RTF file to force the respective applications to use the correct codepage if it isn't the user's default. But most of the issues are pretty straightforward to remedy in one fashion or another.
In general, to get past a wealth of issues today (e.g., availability of fonts, performance, issues with graphs, printer drivers), it's generally easier to set up multiple web/application server environments, each one dedicated to serve a particular locale or range of locales (e.g., Western European). This can be front-ended by a generic servlet that senses the user's browser settings, and redirects to the appropriate environment.
Note for Reports 9i, we've rev'ed up to PDF 1.3 format, and provide support for font embedding and subsetting, and also multibyte support via the 4 Asian font packs that Adobe offers as options for the Acrobat Reader.
There are other locale-specific and multi-locale improvements to Reports 9i, too. But a pure UNICODE web/application server environment will remain a challenge to implement for a few awhile, yet.
The Oracle Reports Team --skw                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       

November 30, -0001

Oracle Reports Font Standardization

We need to make our Oracle database and applications Unicode compliant. To do this we have decided to use the UTF8 character set. The NLS_LANG Oracle registry string can be set to use UTF8. We have decided to use the Andale font. This means the data

How to Change Fonts in Oracle Reports

Hi All, When ever i am changing fonts in my report it reflects me when i run them on reports builder installed on my local machine. But when i put them on application server, these changes are not reflected. I am generating PDF reports. Can some body

HTML font size in Oracle Reports 11g

I am migrating from Oracle Reports 10g in OAS to Reports 11g in WebLogic. However when I display all changed reports using Web Browser (same), the font size is changed(comparing the 10g reports to 11g reports). I would like to keep unchanged. (comman

Oracle Reports - Multi lingual pdf - jvm error

Hi all, We are trying to develop a multilingual pdf report in oracle reports 9i. When we do font subsetting or embedding we get the error: stackpointer=3bb03200 JVMXM004: JVM is performing abort shutdown sequence this error is consistent for font emb

Pass a ViewObject as a data parameter into Oracle Reports

Can I pass a ViewObject as a data parameter in an Oracle Reports jsp Report?you can use impliment this script to your query get data from file function AfterPForm return boolean is infile text_io.file_type; linebuf varchar2(3000) := ''; filename varc

Oracle Reports in PDF output

Hi everyone , We are using Oracle 11g. I have a custom Oracle report in PDF output. In some cases the value is changed. For example, when i run a query in toad i get a value 0.13, then I run my report, check the XML output - the value is still 0.13..

Oracle Reports 11.1.2 junk Arabic characters in PDF

Hi guys, When I generate a report with Arabic characters, they appear as junk characters. I did the following: Set NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256 Include C:\WINDOWS\Fonts in REPORTS_PATH (in the Registry: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KE

Oracle Reports 6i on Oracle EBS 11i Showing Junk Characters

Hello, I have a very simple Oracle Reports 6i reports that needs to run in EBS. I have developed the report and it iis working like a charm when run within the Report 6i tools itself. But when this .rdf file is ported over Oracle EBS and when I run a

Oracle Reports Not working in Web Layout

Hi, I am facing problem to run oracle reports in web layout working fine in paper layout. Please tell me the steps how to fix this problem? Regards, Waqar ShafiqueHello, The easiest way to develop is to use the Report Builder Wizzard.Other example ca

Oracle report-how to change report layout to landscape?

Hi, I am using Oracle report 6i. I want to change the report layout to Landscape. I had tried to go to 'page setup' and changed to 'landscape', but when I print, I still got portait layout. Can anyone help me? Thanks. JunHi, Easiest method for changi

Bullets in oracle Reports

Hi , I want bullets to be dislayed in my oracle reports. I sthere any way i can fect hdata from database with bullets onto my pdf report. Thanks, AshishIn the repeating frame of the row where you require bullets, Draw an ellipse and fill it with blac

Sum function do not work in oracle reports enhanced spreadsheet format

we are using oracle reports in our oracle application server 10gr2 and we are creating enhanced spreed sheet.And the report opens in MS excel fine.But we can not apply any formula like VALUE,SUM,AVG on that report after opening it into excel

Print another PDF inside Oracle Report

We print an oracle report to PDF via oracle Forms, some customers have seperate PDFs that they want to link to the run oracle report. Ideally they want to merge the two into one document. Has anyone had any exprience of this or know of annyway to ach

Saving Oracle report to Database

I want to generate report on report but for that, I need to install Oracle report tables to store the report definition. Can anybody tell me where to get script to create those tables. I am using Report 6i on DBMS 8iNo, I heard that the report RDF fi

Oracle report 10g publsinng on web and Oracle Portal

I am converting a report that was using oracle OAS9i, we pass to URL(rdf file) userid/password and worked fine. We were not using Portal, even though it is installed by OAS. Now seems we have to use Oracle Portal to publish the same report. Is that r

Oracle Reports: Print HTML tags

I am reading data from DB that contains HTML tags and would like the tags to be interpreted when the PDF report is displayed. Currently, the HTML tags are being displayed in the report. When I output the report as a HTML is tags are interpreted and l

Oracle Report in PDF format

Hi, After upgrading from 11.5.7 to 11.5.10 Oracle Report in PDF format is not working(it was working fine in 11.5.7). When change output format to TEXT it working fine. Please advise? Thanks DaveHi, Perhaps it is not clear about what are the invalid

Oracle reports 6i to Oracle forms 10g migration

Hi, I have .rdf files which were created on Oracle Reports 6i. I would like to migrate the .rdf files into Oracle Reports module which is present as a part of Oracle Forms 10g to generate PDF output. Please let me know the detailed steps to be follow

Changing Database Oracle Reports Connection.

Hi Fellows. I would like to know if it is possible to Change Oracle Reports Connection (Ver2.5) after the end user fill in the Parameter Form. I have about 21 agencies with a Database in each one and the end user have to choose the agency what he wan

I am unable to get order by column name in oracle report parameter form