X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-xml%2Fmapping_reports.xml;fp=mig-xml%2Fmapping_reports.xml;h=53665d51a530f651824f4c6ccc343f873fc3483e;hp=47f07e63879803a3c0304f3147f736d490867179;hb=f660d091784fdd0567b1d16698e3dc3fc78f2ae0;hpb=b4193f22989c3974cb627df4da4bb603b1b061e0

diff --git a/mig-xml/mapping_reports.xml b/mig-xml/mapping_reports.xml
index 47f07e6..53665d5 100644
--- a/mig-xml/mapping_reports.xml
+++ b/mig-xml/mapping_reports.xml
@@ -706,6 +706,15 @@
         <query>SELECT cki_notes FROM item_csv_clean WHERE LENGTH(cki_notes) > 1 LIMIT 20;</query>
     </report>
 
+    <report>
+        <name>hz_burbbills</name>
+        <report_title>Count of Bills by Type</report_title>
+        <tag>horizon2</tag>
+        <iteration>0</iteration>
+        <heading>Count.Bill Type</heading>
+        <query>SELECT COUNT(*), block FROM burb_csv_clean WHERE amount::INTEGER > 0 GROUP BY 2;</query>
+    </report>
+
 <!-- resource mate -->
 
     <report>