Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r16880 -r16882 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 16880) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 16882) @@ -9110,7 +9110,7 @@ + " union all " //签收数量 - + "select 'signed' 'type',t6.tousseName tousseName,sum(t6.amount) amount " + + "select 'signed' 'type',t7.tousseName tousseName,sum(t7.amount) amount " + "from (select ti.tousseName,count(*) amount " + "from TousseInstance ti " + "where 1=1 " @@ -9128,8 +9128,8 @@ + "and ti.orgUnitCoding='"+departCoding+"' " + signedTimeString + betweenTemp + "group by fta.tousseName,fta.id) signedTemp " - + "group by signedTemp.tousseName " + (optionSqlArray.length==0?"having signedTemp.tousseName in('')":createInFilterSql("signedTemp.tousseName", optionSqlArray)) + ") t6 " - + "group by t6.tousseName" + + "group by signedTemp.tousseName " + (optionSqlArray.length==0?"having signedTemp.tousseName in('')":createInFilterSql("signedTemp.tousseName", optionSqlArray)) + ") t7 " + + "group by t7.tousseName" ; ResultSet result = objectDao.executeSql(sql);