帆软时间空间联动展示问题

上图日期插件数据绑定时候如何写sql呢

我这样写报了如下错误

FineReport 帆软用户E0gDxPsMIN 发布于 2024-10-29 16:17 （编辑于 2024-10-29 16:22）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共3回答

最佳回答

snrtuemcLv8专家互助
发布于2024-10-29 16:19（编辑于 2024-10-29 16:31）

直接数据集中

select * from 表

where 日期字段='${日期控件名}'

这个格式

=====

你语句拼接问题，拷贝sql，帮你修改下

select COALESCE(SUM(f.fhdsl), 0) AS total_fhdsl from ZS_FHSJHZ f

where 1=1

${if(len(factory) == 0,""," and sapcode = '" + factory + "'")}

${if(len(province) == 0,""," and province_name = '" + province + "'")}

${if(len(startDate) == 0,""," and to_date(fhdate,'yyyy-MM-dd') >= to_date("+startDate+",'yyyy-MM-dd')")}

${if(len(endDate) == 0,""," and to_date(fhdate,'yyyy-MM-dd') >= to_date("+endDate+",'yyyy-MM-dd')")}

举报收起评论(3)

帆软用户E0gDxPsMIN(提问者) sql ：select COALESCE(SUM(f.fhdsl), 0) AS total_fhdsl from ZS_FHSJHZ f where 1=1 ${if(len(factory) == 0,""," and sapcode = '" + factory + "'")} ${if(len(province) == 0,""," and province_name = '" + province + "'")} ${if(len(startDate) == 0,""," and to_date(fhdate,'yyyy-MM-dd') >= to_date(startDate,'yyyy-MM-dd')")} ${if(len(endDate) == 0,""," and to_date(fhdate,'yyyy-MM-dd') >= to_date(endDate,'yyyy-MM-dd')")} 麻烦您帮忙看看

2024-10-29 16:27