帆软中实现控件联动sql

SELECT v.pzmc AS 品种, t.qyj AS 签约价, t.wzj AS 网站价格, t.ckl AS 出口量,

t.tjsj AS 统计时间, v.jsjg AS 结算价格,

(SELECT SUM(a.qyj * a.ckl) / nvl(SUM(a.ckl),1) AS 签约均价

FROM YX_CKYSC a

WHERE

a.pz = t.pz

${if(len(st)=0,""," and a.tjsj between '"+st+"' and '"+et+"' ")}

) AS 签约均价

FROM YX_CKYSC t

JOIN v_yx_ckjsjsjg v ON v.tjsj = SUBSTR(t.tjsj, 1, 6) AND v.pzmc = t.pz

WHERE

${if(len(pz)=0,"and v.pzmc='热轧'"," and v.pzmc='"+pz+"'")}

${if(len(st)=0,""," and t.tjsj between '"+st+"' and '"+et+"' ")}

order by t.统计时间 asc

FineReport yzmEWKxQ4855697 发布于 2023-12-29 08:49

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共1回答

CD20160914Lv8专家互助
发布于2023-12-29 08:53（编辑于 2023-12-29 08:53）

SQL语句实现下拉复选框参数联动 - FineReport帮助文档 - 全面的报表使用教程和学习资料 (fanruan.com)

SQL语句实现下拉框参数联动 - FineReport帮助文档 - 全面的报表使用教程和学习资料 (fanruan.com)

举报收起评论(4)

yzmEWKxQ4855697(提问者) 主要得结合我这个sql 才能展示完全库里sql可以实现，帆软里实现不了

2023-12-29 08:56

yzmEWKxQ4855697(提问者) SELECT v.pzmc AS 品种, t.qyj AS 签约价, t.wzj AS 网站价格, t.ckl AS 出口量, t.tjsj AS 统计时间, v.jsjg AS 结算价格, (SELECT SUM(a.qyj * a.ckl) / nvl(SUM(a.ckl),1) AS 签约均价 FROM YX_CKYSC a WHERE a.pz = t.pz AND a.tjsj >= \'20230425\' AND a.tjsj = \'20230425\' AND t.tjsj <= \'20230525\' AND v.pzmc = \'镀锌无花\'

2023-12-29 08:57