这种使用参数为空选择全部就行了啊下拉框参数为空选择全部-http://help.finereport.com/doc-view-2394.html

SELECT b.*,CONCAT(date_format(b.STARTTIME,'%Y年%c月%d日' ),'-',date_format(b.STARTTIME,'%Y年%c月%d日' ))  as worktime  FROM tb_yhzy_mainproject  b  

where  date_format(b.UPPERDATE,'%Y-%c-%d' )<'${endtime}'  and date_format(b.UPPERDATE,'%Y-%c-%d' )>'${starttime}'   

${if(len(projectname)==0,"","and b.PROJECTNAME = '"+projectname+"'")}

${if(len(orgno)==0,"","and b.ORGNO = '"+orgno+"'")}

${if(len(WORKNAME)==0,"","and b.BUILDER = '"+WORKNAME+"'")}

顺便帮你改了一下，参数为空选择全部的模式，照着试看看

帮助文档看不选当全选的方式~

在控件属性里，去掉允许为空，