Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r13088 -r13091 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 13088) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 13091) @@ -3753,7 +3753,7 @@ } // 材料发货数量 String materialInvoiceAmountSql = "select '' as coding,i.settleAccountsDepart " - + "as depart,mi.amount from MaterialInvoice i inner join MaterialInvoice mi on i.id=mi.materialInvoiceId " + + "as depart,mi.amount from MaterialInvoice i inner join MaterialInvoiceItem mi on i.id=mi.materialInvoiceId " + "where i.orgUnitCoding = '" + handleDeptCode + "' " + " and (mi.amount is not null and mi.amount>0) " + " " + invoiceWheresql;