多层表头报表
概述
多层表头报表：多层表头报表，可以定义任意多层的表头。
应用场景
如下图所示，简单展示数据。
Preview
示例说明
数据准备
在数据面板中添加数据集，可选择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单元格，并设置成分组以及向下扩展，点击上方工具栏-表格设置-数据设置-数据展示，将分组中的合并单元格改为不合并单元格。如下图所示：
Preview
效果预览
Preview