Skip to main content

Beas: Working with QR-Codes in Crystal Reports

Patrik Kludsky
  • Updated

If you want to use a QR-Codes in Crystal Report (Version 2016 or later) with Windows 10, you can do it in the following way:

 

1. Working with QR-Codes needs a special font

 Take the Aztec font-file bcsqrcode.ttf and copy it directly into folder:

C:\Windows\Fonts

 

2. Installation of required libraries so that Crystal Report can generate QR codes

(32- and 64-bit Runtime)

 

Libs:

cruflBcs.dll

cruflBcs_x64.dll

 

These libraries are to be copied into the following directories:

  • cruflBcs.dll file to c:\Windows\SysWoW64
  • cruflBcs_x64.dll to c:\Windows\System32

 

Register the Libraries in Window system (via "cmd"-tool as administrator):

%systemroot%\SysWoW64\regsvr32.exe  %systemroot%\SysWoW64\cruflBcs.dll

%systemroot%\System32\regsvr32.exe  %systemroot%\SysWoW64\cruflBcs.dll

%systemroot%\System32\regsvr32.exe  %systemroot%\\System32\cruflBcs_x64.dll

 

Hint:

The Root-directory could have a different name as windows (Check first and then adjust if necessary)

 

3. Create a Formula with the String with the contents for the QR-Code

(e.g. code_string)

Bild1.png

 

4. Create a Formula for the QR-Code field

(e.g. qr_code)

  1. go to functions
  2. go to “additional functions”
  3. select COM- and .NET-UFLs
  4. take BCSQRCodeEncode

Bild2.png

 

5. Position the QR-Code field and select the QR font

Bild3.png

                                                                                                                                                        mceclip0.png

 

6. Further information on various barcodes

With the addition of the libraries, many more barcode encodings are now available, which can be used in the same way as the QR code description. The corresponding barcode fonts must of course be installed.

 

Latest Libraries and the Font can be found on the web for download.

Related articles

Comments

4 comments

Date Votes
  • Daryl Sensenig

    Thanks for these great instructions. It worked well except when I run the Crystal Report from my application, I get this error. 

    UFL 'u212.com.dll' that implements this function is missing

    0
  • juan 
    Hello, I have a problem, the reports with embedded QR code do not work for me in Windows Server 2022 since it does not allow me to register the dll cruflBcs_x64.dll, do you know how to solve it?
    0
  • Andreas Futterlieb

    Cool instruction! Thank you Volkmar. It worked straight away with CR 11.5.
    Only I struggled with myself as I forgot that I have to open cmd terminal as administrator. :-)
    Kind regards
    Andreas

    0
  • Travis

    I dont understand from point 3 onwards.

    Im really wanting to convert my linear barcodes to QR

    0

Please sign in to leave a comment.