What is barcode in report designer? And how about 1D barcode and 2D barcode?

1. Overview

In Finereport BI, barcode is a graphic identifier to represent a group of information with several black bars and blanks in different widths based on certain coding rules.

There are several types of barcodes in report designer. Barcodes can be divided into one-dimensional barcode (1D barcode) and two-dimensional barcode (2D barcode) based on the number of dimensions.

How to use these two kinds of barcodes will be described below separately.

2. 1D barcode

There are about twenty kinds of 1D barcodes in report designer, including: Code39 (standard Code39), Codabar code, Code25 (standard Code25), ITF25 code (cross 25 code ), Matrix25 code (matrix 25 code ), UPC-A code, UPC-E code, EAN-13 code (EAN-13 international commodity barcode), EAN-8 code (EAN-8 international commodity barcode), China post code (a variant of matrix 25 code), Code-B, MSI code, Code11, Code93, ISBN code, ISSN code, Code128 (Code128, including EAN128 code ), Code39EMS (special EMS Code39). FineReport supports almost all one-dimensional barcodes.

1D barcode will be described below taking Code39 as an example.

Code39 is composed of numeric digits and letters, and is widely used in many industries like industry, book trade and automatic management of tickets. In general, a group of digits will be changed to barcodes. FineReport supports almost all common barcodes.

sp;ISBN code, ISSN code, Code128 (Code128, including EAN128 code ), Code39EMS (special EMS Code39). FineReport supports almost all one-dimensional barcodes.

2.1 Example Code39

New report

Add database query ds1. SQL statement: SELECT * FROM ORDERS

Bind data column

Set as table below:

Cell Data set Data column Attribute
A2 ds1 ORDERID Extend from Top to Down, Rest Default
B2 ds1 CUSTOMERID CUSTOMERID Extend from Top to Down, Rest Default
C2 ds1 SIGNDATE Extend from Top to Down, Rest Default
D2 ds1 SHIPDATE SHIPDATE Extend from Top to Down, Rest Default
E2 ds1 AMOUNT Summary | Sum, No Extension, Rest Default

Table sample design, as shown below:

Set barcode

Right click Cell A2. Select Form > Barcode or select Form > Barcodefrom the Cell Attribute Table at right, as shown:

The Type drop-down box lists various supporting barcode conversion formats. In this case, we select default CODE39.

You can custom barcode width and height. In this table, we use default settings. At the same time, you can select whether to display text (digits in this case) at the same time.

Effect viewing

Effect graph is as follows:

3. 2D barcode

2D barcode means a kind of readable barcode extending from one-dimensional barcode. In 1D barcode (e.g.: barcode), only width records data but length not. In 2D barcode, both length and width record data. In addition, compared with 1D barcode, 2D barcode records have larger amount of and more complex data (e.g., picture). 2D barcode has “positioning point” and “fault-tolerant mechanism”, which are not available in 1D barcode.

Positioning points: in general, 2D barcode has three positioning points, which are provided for identification of barcode reader. Thanks to these positioning points, the 2D barcode can be identified from any reading direction. Fault-tolerant mechanism: with fault-tolerant mechanism, you can correctly restore the barcode information in any incomplete or damaged barcode.

Next, 2D barcode will be described below taking QR Code as an example.

3.1 Example QR code
QR code

QR code is a kind of 2D barcode developed by Denso-Wave (a Japanese company) in 1994. QR is short for quick response, reflecting the idea of source inventor to make the code content decoded quickly. QR code is the most popular and frequently-used 2D space barcode in Japan. Compared with common barcodes, QR code can store more data. In additions, unlike common barcodes, to scan QR code, you are not required to align the scanner.

QR code is initially designed to trace parts in automotive factories. Today, it has been widely applied in inventory management of various industries. The user can connect the scanner or camera to PC with RS-232C interface and decoding program to obtain information contained in QR code. Therefore, QR code is extremely suitable for such enterprise applications as inventory management.

QR code is a square and only consists of black and white. At three corners, there are three small squares like the shape of Chinese character “Hui”. These three squares are used to help decoding software position. The user can correctly read information when scanning in any angle without alignment. Based on the Denso Wave website information, QR code is an open standard. Apart from standard QR code, there is a “micro QR code”, which is a smaller version of standard QR code, designed for applications where large scan cannot be processed. Similarly, micro QR code has several standards and can hold 35 characters at maximum.

QR code effect is as shown below:

Making procedures

Right click a cell. Select Form > Barcode to pop up Define Barcode dialog. Change the Type to QR code, as shown:

Where, version: means storage capacity. The higher is the version number, the larger is the storage capacity. In default, the version number will be automatically adjusted based on the content to be displayed; of course, you can select Custom based on requirements.

Error correction: means error correction capacity. In Level L, 7% of codewords can be restored; in Level M, 15% of codewords can be restored; in Level Q, 25% of codewords can be restored; and in Level H, 30% of codewords can be restored.

Pixel: means the pixel of minimum unit in QR code

In addition: Storage capacities of different QR codes are as shown below: