«

»

Mar 30

Print this Post

SQR output and Fonts

Yes, its graphics…which matters a lot when it comes to output of reports. Especially with SQRs in PeopleSoft where developers are conscious about showing the output of their reports, at the end of day, presentation takes most of the credit.

While there are various options being provided by adobe, however there is limited support for True Type fonts in PeopleSoft. I have been asked to findout where the font setting have been stored/listed in PeopleSoft and in result, I got a file where the fonts and their code has been mentioned.

Below is the extract from the same PS delivered file. You may try with any font which is not listed below and in case if that font is not supported, PS converts it to the default font, which is Courier.

List of defined fonts in PeopleSoft:

Number ————— Name

———————————

3 ———————– Courier
300 ——————– Courier-Bold
4 ———————– Helvetica
400 ——————– Helvetica-Bold
5 ———————– Times-Roman
500 ——————– Times-Bold
6 ———————– AvantGarde-Book
8 ———————– Palatino-Roman
800 ——————– Palatino-Bold
11 ———————- Symbol
12 ———————- ZapfDingbats
17 ———————- ZapfChancery-MediumItalic
18 ———————- Bookman-Light
23 ———————- NewCenturySchlbk-Roman
2300 ——————- NewCenturySchlbk-Bold
30 ———————- Courier-Oblique
3000 ——————- Courier-BoldOblique
31 ———————- Helvetica-Oblique
3100 ——————- Helvetica-BoldOblique
32 ———————- Times-Italic
3200 ——————- Times-BoldItalic
33 ———————- AvantGarde-Demi
34 ———————- AvantGarde-BookOblique
35 ———————- AvantGarde-DemiOblique
36 ———————- Palatino-Italic
3600 ——————- Palatino-BoldItalic
37 ———————- NewCenturySchlbk-Italic
3700 ——————- NewCenturySchlbk-BoldItalic
38 ———————- Helvetica-Narrow
3800 ——————- Helvetica-Narrow-Bold
39 ———————- Helvetica-Narrow-Oblique
3900 ——————- Helvetica-Narrow-BoldOblique
40 ———————- Bookman-Demi
41 ———————- Bookman-LightItalic
42 ———————- Bookman-DemiItalic

You can get this list of delivered SQR fonts in postscri.str file which you can access from the machine where scheduler is installed and configured.

Hope this helps… suggestions are always welcome in case I missed out something…

Permanent link to this article: http://alokbhardwaj.com/oracle-peoplesoft/2009/03/30/sqr-output-and-fonts/

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>