有多个下拉复选框要怎么在数据集里面写sql过滤数据啊?
下拉复选框控件
数据集参数的多选查询
SELECT * FROM 订单 where 货主地区= '${area}' and 货主省份 = '${province}' and 货主城市 in ('${city}')
SELECT * FROM TABLENAME WHERE 1=1 ${IF(LEN(下拉复选框1)==0,""," AND AAAA IN ('"+下拉复选框1+"')")}${IF(LEN(下拉复选框2)==0,""," AND BBB IN ('"+下拉复选框2+"')")}${IF(LEN(下拉复选框N)==0,""," AND NNNNN IN ('"+下拉复选框N+"')")} 这样?
https://help.fanruan.com/finereport10.0/doc-view-2395.html