Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/YearWorkloadReportHelper.java =================================================================== diff -u -r41100 -r41101 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/YearWorkloadReportHelper.java (.../YearWorkloadReportHelper.java) (revision 41100) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/util/YearWorkloadReportHelper.java (.../YearWorkloadReportHelper.java) (revision 41101) @@ -1293,7 +1293,7 @@ + InvoiceItem.class.getSimpleName() + " ii on i.id = ii.invoice_id join " + TousseDefinition.class.getSimpleName() - + " td on td.id=ii.tousseDefinitionId where i.orgUnitCoding='" + querySupplyRoom + "' " + + " td on td.id=ii.tousseDefinitionId where td.integral > 0 and i.orgUnitCoding='" + querySupplyRoom + "' " + " and i.settleaccountsdepart is not null and i.sendTime between " + startDay + " and " + endDay + " group by " + monthlyStr;