Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r16717 -r16775 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 16717) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 16775) @@ -3409,8 +3409,8 @@ private String buildQualityMonitoringCommonSQL2(String queryYear,String nextYear,String departCoding,String formName){ String sql = "select "+dateQueryAdapter.dateConverAdapter3("qi.datetime","mm")+" as everyMonth,sum(qi.amount) from " + "QualityMonitoringInstance qi ,FormInstance fi,FormDefinition fd where qi.id = fi.id and " - + "fi.formDefinition_id = fd.id and fd.formName like '%无菌物品发放错误发生数%' " - +"and qi.datetime between "+dateQueryAdapter.dateAdapter(queryYear) + + " fi.formDefinition_id = fd.id and fd.formName like '%" + formName + "%' " + +" and qi.datetime between "+dateQueryAdapter.dateAdapter(queryYear) + " and "+dateQueryAdapter.dateAdapter(nextYear) + " and fi.orgUnitCoding = '"+departCoding+"'" + " group by "+dateQueryAdapter.dateConverAdapter3("qi.datetime","mm");