需求:报表的参数块中,有很多条件。目前想分为两类;A类有值就按照A条件查询。否则按照B类。具体:工号有值是按照工号查询。否则按照四级部门查询。目前:数据条件where 工号 is not null${if(len(dpt01)=0,""," and mix.单位 = ' "+dpt01+"'")}${if(len(dpt02)=0,""," and mix.一级部门= ' "+dpt02+"'")}${if(len(dpt03)=0,""," and mix.二级部门= ' "+dpt03+"'")}${if(len(dpt04)=0,""," and mix.三级部门= ' "+dpt04+"'")}${if(len(dpt05)=0,""," and mix.四级部门= ' "+dpt05+"'")}界面: