BI Publisher : Print Bar Code in BI Report
1)Create Data Model using below query and Save it in appropriate custom folder
SELECT
poh.segment1 AS po_number,
poh.authorization_status AS po_status,
pov.vendor_name AS supplier_name,
pol.line_num AS line_number,
pol.item_description,
pol.unit_price,
pol.quantity
FROM
po_headers_all poh,
po_lines_all pol,
poz_suppliers_v pov
WHERE
poh.po_header_id = pol.po_header_id
AND poh.vendor_id = pov.vendor_id
AND poh.segment1 = NVL(:p_po_number, poh.segment1)
2) Create report on top of above data model and generate template by wizard
3) Edit report .rtf template
5) Download TFT file ( Template)
6) Change the font format to Bc309 in my rtf template.
7) Upload template and preview output .
8) Font mapping in BIP Administration
BIP>>Administration >>Manage BI Publisher >>Runtime Configuration>>Font Mapping >>
Step1) Upload .tft file
Step2) Add font Mapping
Style=Normal
Weight=Normal
target font type=TRUE
Target Font =Pick uploaded .tft file in step8
Apply>>Return
Test the Report
Configuring font mapping can take few minutes .Refresh report output.
