QR code in oracle reports 11.2

shahid_patel

Hello all, Is there any way to generate QR Code with in oracle reports 11g/11.2 report builder.

Frank Kulash

Hi, @shahid_patel

This question was posted in the SQL and PL/SQL space. There's a separate space for Reports issues:

Reports — oracle-tech

I'll try to move the thread for you.

shahid_patel

ok thanks

Suresh Sangaran-Oracle

Hello,

Similar to barcode as described in https://docs.oracle.com/cd/E24269_01/doc.11120/e24480/orbr_barcode.htm#RSBDR00042

Use the below document steps to generate QRCode in the builder.

How to Generate 2D Barcode / QR Code in Oracle Reports (Doc ID 1678110.1)

Thanks, Suresh

shahid_patel

It is for Bar Code looking for QR Code

user651448

The easiest way to do this is generating the QR code image in the database and then showing the image in the report.

There are some free and paid APIs which provide QR code images. You can use that to generate qr image into the database.

Google API for qr generation is as below.

https://developers.google.com/chart/infographics/docs/qr_codes

Example

https://chart.googleapis.com/chart?cht=qr&chs=200x200&chl=https://oraclescribble.blogspot.com
or
http://chart.googleapis.com/chart?cht=qr&chs=200x200&chl=https://oraclescribble.blogspot.com

https is recommended.

This will create a qr code like below

This can be called from the database and can be saved into a blob.