填报报表不点击查询默认显示全部数据以及点击查询参数为空显示全部数据
下拉框参数为空选择全部-https://help.fanruan.com/finereport/doc-view-2394.html
填报也是一样
组件设置:para,点击查询前不显示报表内容的勾去掉
WHERE 1=1
${if(len(参数1)=0,""," and 字段 = '"+参数1+"'")} -- 单选框
${if(len(参数2)=0,""," and 字段 in ('"+参数2+"')")} -- 复选框,返回值类型字符串,分隔符','
where 1=1 ${if(len(参数)=0, "", " and 条件字段 ="+参数)}