Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/QualityMonitoringInspectMonthReportHelper.java =================================================================== diff -u -r37116 -r38285 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/QualityMonitoringInspectMonthReportHelper.java (.../QualityMonitoringInspectMonthReportHelper.java) (revision 37116) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/QualityMonitoringInspectMonthReportHelper.java (.../QualityMonitoringInspectMonthReportHelper.java) (revision 38285) @@ -291,7 +291,7 @@ + " and fd.formType = '" + monitoringType + "'"+ DataIndex.getIsQualifiedSql("qmi") + fiOrgUnitCodingSql + SqlUtils.getHandleDepartCodingOfQualityMonitoringDefinitionSql(orgUnitCoding) - //+ " and (fiItem.id in (select formInstanceItem_id from FormInstanceOptionValue)) " + + " and exists (select 1 from FormInstanceOptionValue fov where fov.formInstanceItem_id=fiItem.id ) " + " and fdi.isReportDisplay='是' and qmi.dateTime between " + dateQueryAdapter.dateAdapter(startDay) + "and "+dateQueryAdapter.dateAdapter(endDay) + " group by " + " fdi.name ";