Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r14451 -r14456 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 14451) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 14456) @@ -625,7 +625,7 @@ String queryYear = year + "-01-01"; String nextYear = getNextYear(year); - String sql = "select "+dateQueryAdapter.dateConverAdapter3("q.datetime","mm")+" as startMonth,sum(q.amount) as amount from QualityMonitoring q,QualityMonitoringAnswer a,QualityMonitoringItem i" + String sql = "select "+dateQueryAdapter.dateConverAdapter3("q.datetime","mm")+" as startMonth,count(*) as amount from QualityMonitoring q,QualityMonitoringAnswer a,QualityMonitoringItem i" + " where q.id = a.qualitymonitoring_id and a.item_id = i.id and a.questionname = '灭菌方式选择不正确'" + " and q.orgUnitCoding = '"+departCoding+"' and a.answer is not null and q.datetime between "+dateQueryAdapter.dateAdapter(queryYear) + " and "+ dateQueryAdapter.dateAdapter(nextYear)