Reporting needs
A government agency needs to make a registration form of resident identity card application and print the relevant information to the customer. At the same time, each printing form is equipped with a QR code that can check the application progress. Users do not need to log in, but can scan it directly to see.
Effect of the report
Report Design Process
First of all, we need to choose a suitable report tool. Here, we use the building block report platform to design. The specific steps are as follows:
1. Data preparation
A) Create a new table named “User” in the database, which is used to store customer information data
B) Presentation of reports in SQL
- Click “Dataset Management ->SQL Dataset” to enter the interface of Dataset Management, add User table, and parse the data;
2. Template design
A) Design the interface style and drag the data set to the cell;
B) Set QR code properties for dynamic fields;
Select the cell of the two-dimensional code field and set the cell type to “two-dimensional code” on the right to render the two-dimensional code style;
