Skip to main content

Posts

Showing posts from March, 2020

Oracle Cloud Bi Publisher - Print QR Code

Today we are going to see how to print QR Code in Oracle Cloud BI Publisher. I am going to show this using dummy data. I have created a BI Data Model using below SQL SQL: select 'Invoice Number: 12345' || chr(10)  || 'Invoice Date: 2020-01-01' comments from dual Result: BI Publisher QR Code Test I have created a RTF template using below code to print QR Code. <?qrcode:COMMENTS; 100?> Below is the syntax for QR Code: <?qrcode: <DATA>; <SIZE>[; <CHARSET>]?> where DATA – Data to be encoded in the QR code format. SIZE – QR code size dimension in points(pt). CHARSET – (Optional) Character set for encoding the data. Default is UTF8. My DATA is present in the attribute "comments" and I have given the QR Code SIZE as 100. I have ignored the CHARSET as it is optional. I have attached this RTF template to a BI Report. Below is my output. BI Publisher QR Code Output To verify the QR Code, I have saved the QR C