Index: ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/DataIndex.java =================================================================== diff -u -r30685 -r30688 --- ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/DataIndex.java (.../DataIndex.java) (revision 30685) +++ ssts-reports/src/main/java/com/forgon/disinfectsystem/jasperreports/service/dataindex/DataIndex.java (.../DataIndex.java) (revision 30688) @@ -994,7 +994,7 @@ case "发货数量": String miCountSql = null; if(dataSoureOfMaterialsCountOfToussesInReports == 3){ - miCountSql = "case when ti.materialAmount is null then 0 else ti.materialAmount end + case when ti.disposableGoodAmount is null then 0 else ti.disposableGoodAmount end"; + miCountSql = "ti.materialAmount"; joinMaterialInstanceSql = ""; }else{ miCountSql = "mi.count"; @@ -1059,7 +1059,7 @@ case "年度报表中的发货数量(按材料)": if(dataSoureOfMaterialsCountOfToussesInReports == 3){ - amountColumnSql = "case when ti.materialAmount is null then 0 else ti.materialAmount end + case when ti.disposableGoodAmount is null then 0 else ti.disposableGoodAmount end"; + amountColumnSql = "ti.materialAmount"; joinMaterialInstanceSql = ""; }else{ amountColumnSql = "mi.count"; @@ -1103,7 +1103,7 @@ case "核对数量": if(dataSoureOfMaterialsCountOfToussesInReports == 3){ - amountColumnSql = "case when ti.materialAmount is null then 0 else ti.materialAmount end + case when ti.disposableGoodAmount is null then 0 else ti.disposableGoodAmount end"; + amountColumnSql = "ti.materialAmount"; joinMaterialInstanceSql = ""; }else{ amountColumnSql = "mi.count"; @@ -1162,7 +1162,7 @@ case "下送数量": if(dataSoureOfMaterialsCountOfToussesInReports == 3){ - amountColumnSql = "case when ti.materialAmount is null then 0 else ti.materialAmount end + case when ti.disposableGoodAmount is null then 0 else ti.disposableGoodAmount end"; + amountColumnSql = "ti.materialAmount"; joinMaterialInstanceSql = ""; }else{ amountColumnSql = "mi.count";