跳到主要内容

客户订单打印报表

概述​

客户订单打印：采用自由布局方式将数据库表中的数据分散展示。

应用场景​

如下图所示，展示不同客户其订单下的不同数据。

image
Preview

示例说明​

数据准备​

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

[{"订单编号":"ORQTA11071","订购日期":"2023-05-23","地址":"陕西省西安市高新六路34号","电话":15326485219,"E-mail":"45218654@163.com","姓名":"王先生","客户电话":17325486023,"客户地址":"温州路12号","编号ID":"001","商品名称":"饼干","数量":12,"单价":10,"折扣":0.8,"总价":96,"客户订单":"客户订单"},{"订单编号":"ORQTA11072","订购日期":"2023-05-24","地址":"山东省济南市历下区34号","电话":15763458354,"E-mail":"258462176@163.com","姓名":"陈女士","客户电话":15246853594,"客户地址":"福州南路240号","编号ID":"001","商品名称":"巧克力","数量":5,"单价":20,"折扣":0.9,"总价":90,"客户订单":"客户订单"},{"订单编号":"ORQTA11073","订购日期":"2023-05-25","地址":"河北省衡水市78号","电话":15264853278,"E-mail":"254831794@163.com","姓名":"李先生","客户电话":15420065842,"客户地址":"广州路90号","编号ID":"001","商品名称":"绿豆糕","数量":10,"单价":5,"折扣":0.5,"总价":25,"客户订单":"客户订单"}]

报表设计​

勾选打印辅助线，使得所有单元格均在打印辅助线内，可以通过调整行宽列高来实现，将数据集中的数据字段按图中显示拖入到相对应单元格，合并A9-F9单元格，并将其格式设置为【占位】，将C8、D8、E8、F8表格设置成分组，其余设置成分组，按图中颜色添加分组，在打印设置中可自定义打印纸张大小，如下图所示：

image
Preview

效果预览​

客户订单套打_演示.json

image
Preview