Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/QualityMonitoringInspectMonthReportHelper.java =================================================================== diff -u -r38287 -r38288 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/QualityMonitoringInspectMonthReportHelper.java (.../QualityMonitoringInspectMonthReportHelper.java) (revision 38287) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/QualityMonitoringInspectMonthReportHelper.java (.../QualityMonitoringInspectMonthReportHelper.java) (revision 38288) @@ -103,7 +103,7 @@ + SqlUtils.getHandleDepartCodingOfQualityMonitoringDefinitionSql(orgUnitCoding) + fiOrgUnitCodingSql+ DataIndex.getIsQualifiedSql("qmi") //+ SqlUtils.get_InSql_Extra("fi.orgUnitCoding", orgUnitCoding) - + " and fiItem.answer<>'' and fiItem.answer is not null " + + " and exists (select 1 from FormInstanceOptionValue fov where fov.formInstanceItem_id=fiItem.id) " + " and fdi.isReportDisplay='是' and qmi.dateTime between " + dateQueryAdapter.dateAdapter(startTime) + "and "+dateQueryAdapter.dateAdapter(endTime) + " group by " + dateQueryAdapter.dateConverAdapter3("qmi.dateTime","dd") + " ,fdi.name ";