In our example we are going to create QR code for our SSCC using the DefaultProductionLabel.rpt as the base.
Prerequisites:
-
Working with QR-Codes needs a special font
Take the Aztec font-file bcsqrcode.ttf and copy it directly into folder: C:\Windows\Fonts
-
Installation of required libraries so that Crystal Report can generate QR codes
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%\SysWoW64\regsvr32.exe %systemroot%\SysWoW64\cruflBcs_x64.dll
%systemroot%\System32\regsvr32.exe %systemroot%\SysWoW64\cruflBcs.dll
%systemroot%\System32\regsvr32.exe %systemroot%\\System32\cruflBcs_x64.dllHint:
The Root-directory could have a different name as windows (Check first and then adjust if necessary)
Latest Libraries and the Font can be found on the web for download.
-
Copy the dll files to Produmex WMS add-on and Mobile Client installation folders
Add-on folder:
C:\Program Files\SAP\SAP Business One\AddOns\PMX\Produmex Add-On Loader 22
Mobile Client install folder:
C:\Program Files\Produmex\Produmex Fat Client
-
Design the report file:
Open the standard DefaultProductionLabel.rpt and rename it to DefaultProductionLabel_SSCC_QRCODE.rpt
- Create a new formula for the QR code field
-
Choose the newly registered functions and the data you want to encode
In our example we are encoding pmx_sp_productionlabel stored procedure SSCC field.
Add the 00 as AI code to the SSCC code you want to encode
Formula:
BCSQRCodeEncode ('00'+{pmx_sp_productionlabel;1.SSCC})
-
Place the formula to the report set the font to BcsQrCode and save the report.
Hint: you may need to try combination of different font size and alignment to make the barcode fully visible and readable.
-
Test your report
Printout from Crystal Reports
Printout from the Add-on
Printout from Mobile Client
Comments
0 comments
Please sign in to leave a comment.