Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/CustomReportsOfXjjqzyy.java
===================================================================
diff -u -r25745 -r25755
--- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/CustomReportsOfXjjqzyy.java	(.../CustomReportsOfXjjqzyy.java)	(revision 25745)
+++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/CustomReportsOfXjjqzyy.java	(.../CustomReportsOfXjjqzyy.java)	(revision 25755)
@@ -67,7 +67,7 @@
 			operationTimeSql = String.format("and (ti.operationTime < %s) ",
 					dateQueryAdapter.dateAdapter(assemblingEndTime));
 		}
-		String sql = String.format("select f.id from %s f join %s i on f.id=i.id %s where (i.applicationTime between %s and %s ) ",
+		String sql = String.format("select distinct i.id from %s f join %s i on f.id=i.id %s where (i.applicationTime between %s and %s ) ",
 						ForeignTousseApplication.class.getSimpleName(),
 						InvoicePlan.class.getSimpleName(),
 						joinSql,