From e69d37327b1a712f1239599acd511e62ffb6a537 Mon Sep 17 00:00:00 2001
From: garyhgohoos <gary@xtuple.com>
Date: Wed, 18 Jun 2014 16:26:44 -0400
Subject: [PATCH] Issue #21570:add OnlyShowActive param

---
 .../public/tables/report/ItemCostsByClassCode.xml        | 9 +++++++++
 1 file changed, 9 insertions(+)

diff --git a/foundation-database/public/tables/report/ItemCostsByClassCode.xml b/foundation-database/public/tables/report/ItemCostsByClassCode.xml
index ba3438e7f..e5eace801 100644
--- a/foundation-database/public/tables/report/ItemCostsByClassCode.xml
+++ b/foundation-database/public/tables/report/ItemCostsByClassCode.xml
@@ -3,6 +3,12 @@
  <title>Item Costs By Class Code</title>
  <name>ItemCostsByClassCode</name>
  <description></description>
+ <grid>
+  <snap/>
+  <show/>
+  <x>0.05</x>
+  <y>0.05</y>
+ </grid>
  <size>Letter</size>
  <portrait/>
  <topmargin>50</topmargin>
@@ -43,6 +49,9 @@
            FROM item, classcode, uom
           WHERE ((item_classcode_id=classcode_id)
             AND (item_inv_uom_id=uom_id)
+          &lt;? if exists("onlyShowActive") ?>
+            AND (item_active) 
+          &lt;? endif ?> 
           &lt;? if exists("classcode_id") ?>
             AND (classcode_id=&lt;? value("classcode_id") ?>)
           &lt;? elseif exists("classcode_pattern") ?>
-- 
2.39.2