54216
if(len(A5) = 0, "sss", sql("LIMS", " select count(a.sampletemplatename) from(select sampletemplatename,SampleID from V_sjbcx where 1=1 and CONVERT(varchar(10),CustomDateTime1Value,120) between '${开始日期}' and '${结束日期}' and sampletemplatename='" + B3 + "' and EnteredBy = '" + A5 + "' group by sampletemplatename,SampleID) a group by a.sampletemplatename ", 1, 1))当A5有值时进行此查询,当A5无值时进行另外一个查询,当前查询设置好,提示合法的公式,但查询时无数据,将此查询带入数据库可以执行,不知道哪里有问题,请各位大神帮忙看看为什么会这样。