Report Designer GS1-128 Barcodes

Duffanator · June 7, 2022, 11:51am

In the Vision report designer, is there any way to make the barcode component GS1 compliant? If I try and put FNC1 at the beginning of the barcode data the component says Invalid Data. FNC1 at the end of variable length application identifiers also does not work.

PGriffith · June 7, 2022, 3:31pm

You mention both Vision and reporting, so I’m not sure which one you meant, but I believe both are backed by the same open-source library, which has some escape characters mentioned here:

github.com

zxing/zxing/blob/master/core/src/main/java/com/google/zxing/oned/Code128Writer.java#L44

      
        
            
            
private static final int CODE_START_A = 103;
            private static final int CODE_START_B = 104;
            private static final int CODE_START_C = 105;
            private static final int CODE_CODE_A = 101;
            private static final int CODE_CODE_B = 100;
            private static final int CODE_CODE_C = 99;
            private static final int CODE_STOP = 106;
            
            
// Dummy characters used to specify control characters in input
            private static final char ESCAPE_FNC_1 = '\u00f1';
            private static final char ESCAPE_FNC_2 = '\u00f2';
            private static final char ESCAPE_FNC_3 = '\u00f3';
            private static final char ESCAPE_FNC_4 = '\u00f4';
            
            
private static final int CODE_FNC_1 = 102;   // Code A, Code B, Code C
            private static final int CODE_FNC_2 = 97;    // Code A, Code B
            private static final int CODE_FNC_3 = 96;    // Code A, Code B
            private static final int CODE_FNC_4_A = 101; // Code A
            private static final int CODE_FNC_4_B = 100; // Code B

The equivalent text representations would be:

    private static final char ESCAPE_FNC_1 = 'ñ';
    private static final char ESCAPE_FNC_2 = 'ò';
    private static final char ESCAPE_FNC_3 = 'ó';
    private static final char ESCAPE_FNC_4 = 'ô';

They appear to be incorrectly reflected in the text output, but I believe the actual barcode is correct:

Duffanator · June 7, 2022, 4:32pm

Awesome, that worked! Thank you very much, I could not figure out which character to put at the start of the barcode but this worked great:

SELECT *, 'ñ' + '01' + GTIN + '11' + PODate + '10' + SBDate as BarcodeData