如何在模板参数里再添加一个参数

我是在模板参数里这么设置默认日期控件值的，公式代码如下：

IF(DATESUBDATE(TODAY(),SQL("RPA"," select Edate

from (

select K_Festival,Bdate,Edate,activity_type,Flevel,activity_name from FACT_FR_Online_Festival

where activity_type='定金期' AND Flevel='S+' AND activity_name='${activity}'",1),"d")>0,SQL("RPA","select Edate

from (

select K_Festival,Bdate,Edate,activity_type,Flevel,activity_name from FACT_FR_Online_Festival

where activity_type='定金期' AND Flevel='S+' AND activity_name='${activity}'",1),TODAY())

，关联名称为activity的下拉控件，结果不起作用，有没有什么解决办法？

FineReport 用户d9908268 发布于 2021-6-23 12:20

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共2回答

最佳回答

axingLv6专家互助
发布于2021-6-23 12:25

let(a,SQL("RPA"," select Edate from (select K_Festival,Bdate,Edate,activity_type,Flevel,activity_name from FACT_FR_Online_Festival)a where activity_type='定金期' AND Flevel='S+' AND activity_name='"+$activity+"'",1),DATESUBDATE(TODAY(),a,"d")>0,a,today())

举报收起评论(1)

用户d9908268(提问者) 非常感谢，解决了，就是后面表达式少了个if判断： let(a,SQL(\"RPA\",\" select Edate from (select K_Festival,Bdate,Edate,activity_type,Flevel,activity_name from FACT_FR_Online_Festival)a where activity_type=\'定金期\' AND Flevel=\'S+\' AND activity_name=\'\"+$activity+\"\'\",1),IF(DATESUBDATE(TODAY(),a,\"d\")>0,a,today()))

2021-06-23 14:10

snrtuemcLv8专家互助
发布于2021-6-23 12:27

参数没拼接对啊

改成这个

IF(DATESUBDATE(TODAY(),SQL("RPA","select Edate from ( select K_Festival,Bdate,Edate,activity_type,Flevel,activity_name from FACT_FR_Online_Festival) a where activity_type='定金期' AND Flevel='S+' AND activity_name='"+activity+"'",1),"d")>0,SQL("RPA"，"select Edate from (select K_Festival,Bdate,Edate,activity_type,Flevel,activity_name from FACT_FR_Online_Festival) a where activity_type='定金期' AND Flevel='S+' AND activity_name='"+activity+"'",1),TODAY())