Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r16882 -r16892 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 16882) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 16892) @@ -8933,7 +8933,7 @@ + "from invoicePlan ip " + "inner join TousseItem ti on ti.recyclingApplication_ID=ip.id " + "where 1=1 " - + "and ti.isTerminated is null or ti.isTerminated<>1 " + + "and (ti.isTerminated is null or ti.isTerminated<>1) " + "and ip.handleDepartCoding='"+departCoding+"' " + "and ip.applicationTime"+betweenTemp + "group by ti.tousseName "