跳到主要内容

标签打印报表

概述

标签打印:采用自由布局方式将数据库表中的数据分散展示。

应用场景

如下图所示,展示不同物料编码的统计表。

image
Preview

示例说明

数据准备

在数据面板中添加数据集,可选择Json数据集和Http接口数据集,Json数据如下图所示:

[{"物料编码":"21001-00079","物料名称":"电容器","生产日期":"2023-06-28","搬运单":9250355,"排产线体":"55003230511214仓库","公司名称":"百广源外协","品牌":"艾华科技井ERS1HM101F120P","条形码ID":12306127678,"数量":100,"备注":"","二维码":"A101"},{"物料编码":"21001-00080","物料名称":"电容器","生产日期":"2023-06-28","搬运单":9250355,"排产线体":"55003230511214仓库","公司名称":"百广源外协","品牌":"艾华科技井ERS1HM101F121P","条形码ID":12306127678,"数量":100,"备注":"","二维码":"A102"},{"物料编码":"21001-00081","物料名称":"电容器","生产日期":"2023-06-28","搬运单":9250355,"排产线体":"55003230511214仓库","公司名称":"百广源外协","品牌":"艾华科技井ERS1HM101F122P","条形码ID":12306127678,"数量":100,"备注":"","二维码":"A103"},{"物料编码":"21001-00082","物料名称":"电容器","生产日期":"2023-06-28","搬运单":9250355,"排产线体":"55003230511214仓库","公司名称":"百广源外协","品牌":"艾华科技井ERS1HM101F123P","条形码ID":12306127678,"数量":100,"备注":"","二维码":"A104"}]

报表设计

勾选打印辅助线,使得所有单元格均在打印辅助线内,也可以通过调整行宽列高来实现,将数据集中的数据字段按图中显示拖入到相对应单元格,A1二维码单元格中格式设置为【二维码】,B6条形码单元格中格式设置为【条形码】,合并A9-D9单元格,并将其格式设置为【占位】,将D3、B6、 B7、D7表格设置成汇总,其余设置成分组,按图中颜色添加分组,在打印设置中可自定义打印纸张大小,如下图所示:

image
Preview

效果预览

标签打印.json

image
Preview