Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java =================================================================== diff -u -r27342 -r27346 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 27342) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/JasperReportManagerImpl.java (.../JasperReportManagerImpl.java) (revision 27346) @@ -4969,7 +4969,7 @@ lostMaterialFilterSql += " and 1=2 "; damageFilterSql += " and 1=2 "; supplyRoomDiposableGoodsFilterSqlOFDgbs = supplyRoomDiposableGoodsFilterSql + " and dgbs.batchNumber = '"+batch+"'"; - supplyRoomDiposableGoodsFilterSql += " and dbs.batchNumber = '"+batch+"'"; + supplyRoomDiposableGoodsFilterSql += " and dgbs.batchNumber = '"+batch+"'"; outEntryFilterSql += " and dgbs.batchNumber = '"+batch+"'"; } @@ -5726,7 +5726,7 @@ lostMaterialFilterSql += " and 1=2 "; damageFilterSql += " and 1=2 "; supplyRoomDiposableGoodsFilterSqlOFDgbs = supplyRoomDiposableGoodsFilterSql + " and dgbs.batchNumber = '"+batch+"'"; - supplyRoomDiposableGoodsFilterSql += " and dbs.batchNumber = '"+batch+"'"; + supplyRoomDiposableGoodsFilterSql += " and dgbs.batchNumber = '"+batch+"'"; outEntryFilterSql += " and dgbs.batchNumber = '"+batch+"'"; }