https://help.fanruan.com/finereport/doc-view-2395.html?source=1 参数为空选择全部 

所有参数都用这个方法  五个参数只选两个参数就会出来符合这两个参数的数据

${if(len(参数名字) == 0,"","and 参数字段 = ('" + 参数名 + "')")}

参数这样写

SELECT * FROM 表名
where 1=1  
${if(len(参数1) == 0,"","and 字段1 in ('" + 参数1 + "')")}
${if(len(参数2) == 0,"","and 字段2 in ('" + 参数2 + "')")}
${if(len(参数3) == 0,"","and 字段3 in ('" + 参数3 + "')")}
${if(len(参数4) == 0,"","and 字段4 in ('" + 参数4 + "')")}
${if(len(参数5) == 0,"","and 字段5 in ('" + 参数5 + "')")}

五个字段用这种方式：

where 1=1

${if(len(字段1) == 0,"","and 字段1 = '"+ 字段1 +"'")}

${if(len(字段2) == 0,"","and 字段2 = '"+ 字段2 +"'")}

${if(len(字段3) == 0,"","and 字段3 = '"+ 字段3 +"'")}

${if(len(字段4) == 0,"","and 字段4 = '"+ 字段4 +"'")}

${if(len(字段5) == 0,"","and 字段5 = '"+ 字段5 +"'")}