finereport传参自定义维度

报表前端可以传参，SQL如何去控制维度从而计算销售额比较好

FineReport VincentYph 发布于 2023-8-1 14:48

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共3回答

最佳回答

Z4u3z1Lv6专家互助
发布于2023-8-1 14:51（编辑于 2023-8-1 15:10）

SELECT ${IF(参数==1,"门店","种类")} [TYPE_],时间,SUM(销售额) [SUM_] FROM TABLE group BY ${IF(参数==1,"门店","种类")},时间

-------------

WorkBook1.rar

举报收起评论(9)

yisheng DS1和DS2能否发数据看一下？

2024-06-11 13:48

Z4u3z1 回复 yisheng 23年的东西了。上面压缩包里没有么？

2024-06-11 13:53

yisheng 回复 Z4u3z1 按你的格式写报错的 WITH T1 AS ( select 'A001' as 门店,'A' as 种类, '202406' as 时间,5 as 销售额 from dual union select 'A001' as 门店,'B' as 种类, '202406' as 时间,5 as 销售额 from dual union select 'A002' as 门店,'A' as 种类, '202406' as 时间,10 as 销售额 from dual ) SELECT ${IF(参数==1,"门店","种类")} [TYPE_],时间,SUM(销售额) [SUM_] FROM T1 group BY ${IF(参数==1,"门店","种类")},时间

2024-06-11 14:03