QR Codes in Oracle Reports
By Markus -Oracle on Jun 16, 2014
QR codes are pretty popular, especially for paper based workflows and in logistics. "Quick Response Code" is a two dimensional (2D) visual representation of any alphanumeric string. Main purpose - same as with barcodes - is to integrate paper with computers, aka offer machine readability.
Depending on the use case, different variations of QR codes are established, like Micro-QR-Code, Secure-QR-Code (SQRC), iQR-Code. Typically their specifications differ in dimension and number of elements (which basically refers to the amount of data that can be represented with it).
Also several (country specific) industrial standards (like JIS X 0510, GB/T 18284, ISO/IEC 18004) as well as de-facto standards (like OpenSource XZing) are in place, and so do many programs generating them (QR Code Generator).
Oracle Reports has the ability to integrate external Java programs while the report is executed. Existing reports can be modernized that way and additional functionality can be added. A nice use case is demonstrated for the Barcode Bean. The barcode is generated on the fly and added for any destination format. Find details about the concept, implementation and coding in
of the main reference manual Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports 11g Release 2 (11.1.2).
For QR Codes integration into Oracle Reports, the same concept comes into place:
How to Generate 2D Barcode / QR Code in Oracle Reports (Doc ID 1678110.1)
This brand new sample code comes with demo RDF, Java coding required and setup instructions. It is based on OpenSource QR code generators.
Give it a try and let us know your experience!