参数书写怎么修改获取到参数

大佬们这个怎么用FR的书写格式获取到type这个参数？

FineReport CYJXJ 发布于 2025-1-16 11:31

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共2回答

最佳回答

Z4u3z1Lv6专家互助
发布于2025-1-16 12:14

${if(p1 = "接收","

SELECT

SUM(

CASE

WHEN '"+tax+"' = '税收' THEN tax_in

WHEN '"+tax+"' = '不含税收' THEN net_wo

END

) money

FROM

***

WHERE

data_year = '"+ year +"'"+ if(type ='true',"and type = '3'","and type = '1'")+""," ")}

snrtuemcLv8专家互助
发布于2025-1-16 11:33（编辑于 2025-1-16 11:41）

这个${}里面就不要${}了，需要拼接

拷贝下语句，帮你修改吧

=========

${if(p1="接收"," select

sum(

case

when '"+tax+"'='税收' then tax_in

when '"+tax+"'='不含税收' then net_wo

end ) money

from biao

where data_year='" +year+"'"+

if(type='true'," and type='3'"," and type='1'"),

"")}

举报收起评论(3)

CYJXJ(提问者) ${if(p1 = "接收","
SELECT
SUM(
CASE
WHEN '${tax}' = '税收' THEN tax_in
WHEN '${tax}' = '不含税收' THEN net_wo
END
) money -- 金额
FROM
***
WHERE
data_year = '"+ year +"'
${if(type ='true',"and type = '3'","and type = '1'")}
"," ")}

2025-01-16 11:35