cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to create a QR code directly from Crystal Reports?

odlarhg
Discoverer
161

Hello,

I have little experience with Crystal Reports, but as part of my job I have been asked to create a report in which some data and a QR code are displayed from the information contained in two of the database fields. Is it possible to create a QR code directly from Crystal Reports? Can you help me by telling me how QR codes can be created in Crystal Reports or where I can obtain information on this topic?

Thank you very much in advance.

Accepted Solutions (1)

Accepted Solutions (1)

ido_millet
Active Contributor
0 Kudos

See a review of several options here.

Answers (1)

Answers (1)

Creating a QR code directly from Crystal Reports is definitely possible. You have a couple of options to achieve this.

*Option 1: Using a Native Generator*
You can use a native generator like the one provided by IDAutomation.¹ This tool allows you to create QR codes directly in Crystal Reports without installing any fonts. It supports various QR code formats, including standard QR Code, GS1-QRCode, AIM-QRCode, and Micro QR-Code.

*Option 2: Using a Formula and Barcode Font*
Another option is to use a formula to generate the QR code and a barcode font to display it. You can follow these steps:

1. *Create a new formula*: In the Field Explorer, right-click on Formula Fields and click New. Name the formula, for example, "QRCode".
2. *Copy the formula text*: Copy the QR code formula provided by BarCodeWiz² into the Formula Editor. This formula generates the QR code based on the data you provide.
3. *Replace the data*: Replace the "Hello..." text in the formula with your own data field. For example: `local stringVar barcodeInput := {my_data_table.item_text};`
4. *Add a barcode font*: Download and install a QR code barcode font, such as BCW_QR. Then, drag the formula from the Field Explorer to the report and change the font to BCW_QR.

Both options should allow you to create a QR code directly in Crystal Reports. If you need more information or guidance, feel free to ask!