sql 语句写的不对参考这个文档
https://help.fanruan.com/finereport/doc-view-2395.html?source=4
逻辑写错了 ${if(len(prod_type) == 0,""," and prod_type in( '" + prod_type+ "')")}
然后记得把控件的分隔符加上这个','