报表查询复选框,怎么设置能够查询多个选项,sql和设置如下
${if(SAP_XSZDESC !='',"and zsd01.FCREATER in ('" + SAP_XSZDESC + "')","")}
你这配置没问题啊
----------------
可以稍微改一下
${if(len(SAP_XSZDESC)<>0,"and zsd01.FCREATER in ('" + SAP_XSZDESC + "')","")}
${if(len(SAP_XSZDESC )!=0,"and zsd01.FCREATER in ('" + SAP_XSZDESC + "')","")}
=====