我写报表的时候用到了复选框file:///C:\Users\Administrator\Documents\Tencent Files\892673862\Image\C2C\N6KQBN1EUQ8@JCPNN@5`SZ3.png然后我设置了个变量接收复选框选中的值 现在我选择一个的时候 sql里面是可以查出来的 但是选择多个后就查不出来数据了file:///C:\Users\Administrator\Documents\Tencent Files\892673862\Image\C2C\]YI%GF4}L@~H%3@ZI9%}870.png
SQL如下:
select
j.fareacode,
j.fareaname,
j.fareacode as area,
sum(j.fjsyd_in) as xdjsyd,
sum(j.fjsyd_out) + sum(j.fjsyd_surplus) + sum(j.fjsyd_frozen) as syjsyd,
sum(j.fnyd_in) as xdnyd,
sum(j.fnyd_out)+sum(j.fnyd_surplus)+ sum(j.fnyd_frozen) as syfnyd,
sum(j.fgd_in) as xdgd,
sum(j.fgd_out)+sum(j.fgd_surplus)+ sum(j.fgd_frozen) as sygd
from gh_t_yearIndexLedger j
where j.fyear = '${year}' and (j.fareacode <> '${areacode}' and '${areacode1}' is null )or(j.fareacode in '||${areacode1}||' and '${areacode1}' is not null)
group by j.fareaname,j.fareacode order by fareacode
其中:areacode1 为复选框获得到的变量,当选中一个复选框时好的,选中多个时就出不来值了