SAP Business One SDK Support

Add QR Code in Crystal Report - Method 1 (Need to Buy the DLL)

There is patch available  in SAP B1 10, which have in-build solution for this process. You can check this HERE (Method 2).

The below method is used for SAP B1 9.3,9.2 all patches. This is a paid method, Client need to buy the required DLL for this method.

Please check the website : https://www.morovia.com/

 After installing the above link software you can follow the below 5 steps :

1. Open the Crystal Report with all the Relevant data and Design.

2. Create a formula Filed and Past the below code

// Crystal Reports impose a constraint on UFL string length: max 255 characters.
// To get around this limit, use the code below
// This workaround requires Crystal Report Version >= 9

StringVar DataToEncode := {BarcodeHD_DTL};

        StringVar CompleteBarcodeString:="";

NumberVar i:=0;
NumberVar Segments:=
QRCodeEncodeSet(DataToEncode, 0, 0);
For i:=0 to Segments Do
(
   CompleteBarcodeString := CompleteBarcodeString +
             QRCodeEncodeGet(i);
);
CompleteBarcodeString

3. Set you filed by replacing BarcodeHD_DTL 

Advertisement



4. Drag and set this new formula field inside the design.

5. Right-Click and open the Format Editor of the Formula Filed and set as shown below.

 

 6. Go to Paragraph Tab and Set the Line Spacing as below.

  

 7. Save and check the preview.

 

 

You can Download the sample file + DLL demo here.

No comments: