Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/NurseWorkloadReportHelper.java =================================================================== diff -u -r37116 -r38781 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/NurseWorkloadReportHelper.java (.../NurseWorkloadReportHelper.java) (revision 37116) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/NurseWorkloadReportHelper.java (.../NurseWorkloadReportHelper.java) (revision 38781) @@ -370,8 +370,8 @@ */ private String buildSqlOfSterilizeTotalSql(String betweenSql){ String monthlyStr = dateQueryAdapter.dateToVarchar2("endDate"); - return String.format(" select %s monthstr, sum(amount) amount ,ou.name" + return " select "+ monthlyStr +" monthstr, sum(amount) amount ,ou.name" + " from SterilizationRecord sr inner join OrgUnit ou on ou.orgUnitCoding=sr.orgUnitCoding " - + " where endDate %s and sr.status='%s' group by %s ,ou.name ", monthlyStr,betweenSql,SterilizationRecord.STERILIZATION_STATUS_END,monthlyStr); + + " where endDate "+ betweenSql +" and sr.status='"+ SterilizationRecord.STERILIZATION_STATUS_END +"' group by "+ monthlyStr +" ,ou.name "; } }