【报表-布局设计】报表的动态列排序

在Wyn中可以不仅可以实现报表的动态列，也可以对列进行排序，我们先来看一下效果：
选择每列的排序序号


根据所设置的排序序号显示列的顺序




好了下面是解密时间：


那么怎样能够完成这样一个动态列排序呢？


这里使用了强大的表达式的能力：

使用表达式swich来判断每个单元格显示的数据

依次类推，每一列都需要配置以上的公式来实现动态列的排序。

列头文本

1. {Switch(@订单编号排序 = "1" and "," & Join(@动态列, ",") & "," like "*,1,*", "订单编号", @支付方式排序 = "1" and "," & Join(@动态列, ",") & "," like "*,2,*", "支付方式", @订购日期排序 = "1" and "," & Join(@动态列, ",") & "," like "*,3,*", "订购日期", @购买数量排序 = "1" and "," & Join(@动态列, ",") & "," like "*,4,*", "购买数量")}

复制代码

列的数据内容

1. {Switch(@订单编号排序 = "1" and "," & Join(@动态列, ",") & "," like "*,1,*", 订单编号, @支付方式排序 = "1" and "," & Join(@动态列, ",") & "," like "*,2,*", 支付方式, @订购日期排序 = "1" and "," & Join(@动态列, ",") & "," like "*,3,*", 订购日期, @购买数量排序 = "1" and "," & Join(@动态列, ",") & "," like "*,4,*", 购买数量)}

复制代码

后附demo示例。


今天你学到了吗？