Tuesday 27 September 2011

Configure Oracle Report Server to Display correctly Greek fonts in PDF and HTML format


Upload the arial font in ttf format and pfa format
arialbi.ttf
arialbd.ttf
ariali.ttf
arial.ttf
[oraclefrm@srvas1 AFM]$ od -a ariali | grep
Usage: grep [OPTION]... PATTERN [FILE]...
Try `grep --help' for more information.
[oraclefrm@srvas1 AFM]$ od -a arial|grep cr
[oraclefrm@srvas1 AFM]$ od -a arialbi|grep cr
[oraclefrm@srvas1 AFM]$ od -a arialbd|grep cr
[oraclefrm@srvas1 AFM]$ od -a ariali|grep cr
[oraclefrm@srvas1 AFM]$



Rename arial to :
mv arial   ArialMT
mv arialbd Arial-BoldMT
mv ariali  Arial-ItalicMT
mv arialbi Arial-BoldItalicMT



Add In screenprinter.ppd:
*Font ArialMT: Standard "(001.004)" Standard ROM
*Font Arial-BoldMT: Standard "(001.004)" Standard ROM
*Font Arial-ItalicMT: Standard "(001.004)" Standard ROM
*Font Arial-BoldItalicMT: Standard "(001.004)" Standard ROM


[oraclefrm@srvas1 bin]$ vi reports.sh
Add the application reports’ repository
REPORTS_PATH=$ORACLE_HOME/reports/rdf:$ORACLE_HOME/reports/fonts
:$ORACLE_HOME/reports/templates:$ORACLE_HOME/reports/samples/demo
:$ORACLE_HOME/reports/integ:$ORACLE_HOME/reports/printers:${REPORTS_PATH};
export REPORTS_PATH

Add the end add:
NLS_LANG=AMERICAN_AMERICA.EL8ISO8859P7; export NLS_LANG

Copy the Arial fonts under AFM into $ORACLE_HOME/reports/fonts
Transfer binary the *.ttf file into $ORACLE_HOME/reports/fonts

Comment out the Arial at the beginning of the file uifont.ali and
add the following lines in uifont.ali under [ PDF:Subset ]section
[PDF:Subset ]
Arial..Italic.Bold.. = "arialbi.ttf"
Arial...Bold.. = "arialbd.ttf"
Arial..Italic... = "ariali.ttf"
Arial..... = "arial.ttf"