多层表头报表

概述

多层表头报表：多层表头报表，可以定义任意多层的表头。

应用场景

如下图所示，简单展示数据

示例说明

数据准备

在数据面板中添加数据集，可选择Json数据集和API服务数据集。Json数据集输入如下图所示：

[{"到货日期":"2023-05-09","订单名称":"订单1","订单日期":"2023-05-05","订单编号":"A0001","订单金额":149,"订购数量":45,"订单统计表":"订单统计表"},{"到货日期":"2023-05-10","订单名称":"订单2","订单日期":"2023-05-06","订单编号":"A0002","订单金额":156,"订购数量":23,"订单统计表":"订单统计表"},{"到货日期":"2023-05-11","订单名称":"订单3","订单日期":"2023-05-07","订单编号":"A0003","订单金额":854,"订购数量":67,"订单统计表":"订单统计表"},{"到货日期":"2023-05-12","订单名称":"订单4","订单日期":"2023-05-08","订单编号":"A0004","订单金额":157,"订购数量":15,"订单统计表":"订单统计表"},{"到货日期":"2023-05-13","订单名称":"订单5","订单日期":"2023-05-09","订单编号":"A0005","订单金额":642,"订购数量":67,"订单统计表":"订单统计表"},{"到货日期":"2023-05-14","订单名称":"订单6","订单日期":"2023-05-10","订单编号":"A0006","订单金额":945,"订购数量":89,"订单统计表":"订单统计表"},{"到货日期":"2023-05-15","订单名称":"订单7","订单日期":"2023-05-11","订单编号":"A0007","订单金额":149,"订购数量":45,"订单统计表":"订单统计表"},{"到货日期":"2023-05-16","订单名称":"订单8","订单日期":"2023-05-12","订单编号":"A0008","订单金额":156,"订购数量":23,"订单统计表":"订单统计表"},{"到货日期":"2023-05-17","订单名称":"订单9","订单日期":"2023-05-13","订单编号":"A0009","订单金额":854,"订购数量":67,"订单统计表":"订单统计表"},{"到货日期":"2023-05-18","订单名称":"订单10","订单日期":"2023-05-14","订单编号":"A0010","订单金额":157,"订购数量":15,"订单统计表":"订单统计表"},{"到货日期":"2023-05-19","订单名称":"订单11","订单日期":"2023-05-15","订单编号":"A0011","订单金额":642,"订购数量":67,"订单统计表":"订单统计表"}]

报表设计

在顶部行编辑表头，并合并单元格。
将数据字段拖入到A3、B3、C3、D3、E3、F3、G3单元格，并设置成分组以及向下扩展，点击上方工具栏-表格设置-数据设置-数据展示，将分组中的合并单元格改为不合并单元格。如下图所示：

效果预览

多层表头报表.json

参考文档

• 小智报表样例源码下载
  • https://gitee.com/tizdata_admin/vue-xzreport-example.git
• 小智报表demo体验
  • https://xzdemo.tizdata.com/#/imbedShow/reportExample
  • 丰富的报表模板示例
• 小智报表在线试用
  • https://xzreport.com
• 小智报表js sdk下载
  • https://tizdata.com/xzdownload/
• 开发使用文档
  • https://doc.tizdata.com/xiaozhi/650

ps://doc.tizdata.com/xiaozhi/650

下一篇 图像文字报表