Crystal Report Display dynamic picture

Background

The company warehouse is hand key number to receive material, in order to avoid key error, add two-dimensional code picture on the document, scan read, document is generated with Crystal report, the problem becomes how to display the two-dimensional code on the Crystal Report dynamically

Solution Ideas

1. Create a two-dimensional code image with Zxing, and save the image in a byte array

CREATE table in 2.sql server with varbinary type, Oracle as BLOB type, insert byte array into this field

3. Create an XSD file based on the table to bind to the Crystal Report

4. Drag the picture field onto the Crystal Report to display

Crystal Report Display dynamic picture