BARCODE in XML Reports

BARCODE in XML Reports


For generating reports with Barcodes

1)    You should have barcode font in your system i.e. Font name.
2)    Copy and paste the “Free 3of9” font in your machine directories “C:\WINDOWS\Fonts” and $JAVA_HOME\ lib\fonts
Example Java path “C:\Program Files\Java\j2re1.4.2_10\lib\fonts”.
3)    There is one configuration file i.e. file name is “xdo”.
4)    Copy and paste the configuration file in your “XML Publisher Desktop\Template Builder for Word\config”
Example:
“C:\PROGRAM Files\Oracle\XML Publisher Desktop\TEMPLATE Builder FOR Word\config”
?xml version = '5.5.0' encoding = 'UTF-8'?
config VERSION="1.0.0" xmlns="http://xmlns.oracle.com/oxp/config/"
fonts
font family="Free 3 of 9" style="normal" weight="normal"
truetype PATH="C:\Program Files\Java\j2re1.4.2_12\lib\fonts\FREE3OF9.TTF"/
/font
/fonts
/config

       Include the tags (Here tags are not post)...

       Check the configuration file once.
5)    Once you have done the above setups, you can see the “Free 3of 9” font type under your MSWORD font.
6)    Which column you have to display as barcode, just put this font to that column.

NOTE: While convert the data to upper case before generating the XML do it at the SQL level only.


No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...