Index: ssts-web/src/main/webapp/jasperRtp/materialMissTotalView.jrxml
===================================================================
diff -u -r14753 -r17512
--- ssts-web/src/main/webapp/jasperRtp/materialMissTotalView.jrxml	(.../materialMissTotalView.jrxml)	(revision 14753)
+++ ssts-web/src/main/webapp/jasperRtp/materialMissTotalView.jrxml	(.../materialMissTotalView.jrxml)	(revision 17512)
@@ -34,9 +34,8 @@
      r.materialname,
      case when r.materialcost is null then 0.00 else r.materialcost end  price
 FROM
-     recyclingerror r
-WHERE
-     r.tousseitem_id IS not null
+     MaterialErrorDamageDetail r
+WHERE 1= 1
      $P!{querySql}
 GROUP BY
      r.materialname,