• qrcode barcode download
  • qrcode barcode order

Print QRCode in Crystal Reports

QRCode is a 2D barcode that is able to encode more than 1000 alphanumeric characters.

To print QRCode in Crystal Reports, it's a smart and simple solution to use Barcodesoft UFL (User Function Library) and BCSQRCode barcode font.

1. Install QRCode demo on your computer.

2. Open DOS prompt. If you are using Windows 10 or Windows 7, please Open DOS prompt as administrator.
Please go to the following folder
CD C:\Program Files\Common Files\Barcodesoft\FontUtil
Type in the following DOS command to register crUFLbcs.dll
regsvr32 crUFLbcs.dll
qrcode crystal reports DLL DOS registration

3. Open your crystal report. Right click Formula Fields, choose "New..." from the context menu. Type in "qrcode" in the Name textbox, then click "Use Editor".

qrcode create formual crystal reports

After QRCode encoding process, even a short string might return more code words than you expect.
However, Crystal Reports allows no more than 255 characters in a formula field.
Therefore we have to split QRCode code words into separate parts, and concatenate them in a Text Object before apply font BcsQRCode to the Text Object.
As for how many formula fields are needed, you can find out by using the following function BCSQRCodeFormulaNoForCR.

4. Create more formula fields as listed below if returned code words are more than 255. Then put them in sequence within the same Text Object.

BCSQRCodeEncodeCR({Test.Data}, 1, 1)
BCSQRCodeEncodeCR({Test.Data}, 2, 1)
BCSQRCodeEncodeCR({Test.Data}, 3, 1)

The first parameter in the formula field is string to encode.
The second parameter in the formula field is index.
The third parameter in the formula field is error correction level. Its value ranges between 1 and 4 that represents L07, M15, Q25 and H30 separately. When set to default value 0, it stands for M15 error correction level.

For detailed explanations of each parameter, please refer to user's manual.

qrcode crystal reports UFL formula field

5. Right click Text Object and choose "Format Object" from context menu. Then choose "BcsQRcode" as font typeface for the Text Object.

  • qrcode crystal reports download
  • qrcode software order