r6512 - trunk/gnue-reports/samples/foobulations

[btami]

Author: btami
Date: 2004-10-19 06:29:32 -0500 (Tue, 19 Oct 2004)
New Revision: 6512

Added:
   trunk/gnue-reports/samples/foobulations/char.grd
   trunk/gnue-reports/samples/foobulations/foobulations.gsd
Log:
added a char layout sample report

Added: trunk/gnue-reports/samples/foobulations/char.grd
===================================================================
--- trunk/gnue-reports/samples/foobulations/char.grd    2004-10-19 11:26:37 UTC 
(rev 6511)
+++ trunk/gnue-reports/samples/foobulations/char.grd    2004-10-19 11:29:32 UTC 
(rev 6512)
@@ -0,0 +1,70 @@
+<?xml version="1.0"?>
+<report>
+  <sources>
+   <datasource connection="gnue" name="dtsFoo" table="foobulations" 
order_by="name,color,foodate"/>
+  </sources>
+  <layout xmlns:out="GNUe:Reports:Char">
+  
+   <out:report width="80" height="15">
+
+    <out:pageheader height="4">
+      <out:label x="30" y="0" width="37">Monthly Accounting Foobulation 
Report</out:label>
+      <out:label x="0" y="2" width="4">Name</out:label>
+      <out:label x="20" y="2" width="5">Color</out:label>
+      <out:label x="40" y="2" width="4">Date</out:label>
+      <out:label x="65" y="2" width="5">Foobs</out:label>
+      <out:label x="0" y="3" width="4">====</out:label>
+      <out:label x="20" y="3" width="5">=====</out:label>
+      <out:label x="40" y="3" width="4">====</out:label>
+      <out:label x="65" y="3" width="5">=====</out:label>
+    </out:pageheader>
+
+    <out:pagefooter height="3">
+      <out:label x="0" y="2" width="15">Berado '88 Kft.</out:label>
+    </out:pagefooter>
+    
+        <section source="dtsFoo" name="mynameBreak">
+          <out:groupheader height="1">
+            <out:label x="0" y="0" width="20"><field name="name"/></out:label>
+          </out:groupheader>
+
+        <section name="mycolorBreak">
+<!--
+          <out:groupheader height="1">
+            <out:label x="10" y="0" width="10"><field 
name="color"/></out:label>
+          </out:groupheader>
+-->
+          <section name="details">
+            <out:detail height="1">
+              <out:label x="20" y="0" width="15"><field 
name="color"/></out:label>
+              <out:label x="40" y="0" width="25"><field 
name="foodate"/></out:label>
+              <out:label x="65" y="0" width="10"><field 
name="foobs"/></out:label>
+            </out:detail>
+          </section>
+
+          <out:groupfooter height="2">
+            <out:label x="50" y="0" width="12"><field name="color"/> 
total</out:label>
+            <out:label x="65" y="0" width="10" bold="Y"><summ function="sum" 
section="details" field="foobs"/></out:label>
+          </out:groupfooter>
+        </section>
+
+          <out:groupfooter height="1">
+            <out:label x="50" y="0" width="12"><field name="name"/> 
total</out:label>
+            <out:label x="65" y="0" width="10" bold="Y"><summ function="sum" 
section="mycolorBreak" field="foobs"/></out:label>
+          </out:groupfooter>
+        </section>
+
+    <out:titlepage>
+      <out:label x="35" y="10" width="17" bold="Y" italic="Y">Grand Char 
Report</out:label>
+      <out:label x="35" y="11" width="17" 
bold="Y">=================</out:label>
+    </out:titlepage>
+
+    <out:summarypage>
+      <out:label x="50" y="2" width="12">Grand total</out:label>
+      <out:label x="65" y="2" width="10"><summ function="sum" 
section="mynameBreak" field="foobs"/></out:label>
+    </out:summarypage>
+
+   </out:report>
+
+  </layout>
+</report>

Added: trunk/gnue-reports/samples/foobulations/foobulations.gsd
===================================================================
--- trunk/gnue-reports/samples/foobulations/foobulations.gsd    2004-10-19 
11:26:37 UTC (rev 6511)
+++ trunk/gnue-reports/samples/foobulations/foobulations.gsd    2004-10-19 
11:29:32 UTC (rev 6512)
@@ -0,0 +1,121 @@
+<?xml version="1.0"?>
+<schema>
+  <tables>
+    <table name="foobulations">
+      <fields>
+        <field name='id' type="number" defaultwith="serial" nullable="N"/>
+        <field name="name" type="string" length="20" nullable="N"/>
+        <field name="foodate" type="date"/>
+        <field name="color" type="string" length="10"/>
+        <field name="foobs" type="number" length="8"/>
+      </fields>
+      <primarykey name="pk_foobulations">
+        <pkfield name="id"/>
+      </primarykey>
+    </table>
+</tables>
+<data>
+  <tabledata name="foobulations_data" tablename="foobulations">
+    <rows>
+      <row>
+        <value field="id">1</value>
+        <value field="name">Mandy</value>
+        <value field="foodate">04/01/02</value>
+        <value field="color">white</value>
+        <value field="foobs">300</value>
+      </row>
+      <row>
+        <value field="id">2</value>
+        <value field="name">Mandy</value>
+        <value field="foodate">04/02/02</value>
+        <value field="color">white</value>
+        <value field="foobs">402</value>
+      </row>
+      <row>
+        <value field="id">3</value>
+        <value field="name">Mandy</value>
+        <value field="foodate">04/03/02</value>
+        <value field="color">white</value>
+        <value field="foobs">1000</value>
+      </row>
+      <row>
+        <value field="id">4</value>
+        <value field="name">Mandy</value>
+        <value field="foodate">04/04/02</value>
+        <value field="color">white</value>
+        <value field="foobs">3301</value>
+      </row>
+      <row>
+        <value field="id">5</value>
+        <value field="name">Mandy</value>
+        <value field="foodate">04/01/02</value>
+        <value field="color">black</value>
+        <value field="foobs">300</value>
+      </row>
+      <row>
+        <value field="id">6</value>
+        <value field="name">Mandy</value>
+        <value field="foodate">04/02/02</value>
+        <value field="color">black</value>
+        <value field="foobs">402</value>
+      </row>
+      <row>
+        <value field="id">7</value>
+        <value field="name">Mandy</value>
+        <value field="foodate">04/03/02</value>
+        <value field="color">black</value>
+        <value field="foobs">1000</value>
+      </row>
+      <row>
+        <value field="id">8</value>
+        <value field="name">Candy</value>
+        <value field="foodate">04/01/02</value>
+        <value field="color">white</value>
+        <value field="foobs">30</value>
+      </row>
+      <row>
+        <value field="id">9</value>
+        <value field="name">Candy</value>
+        <value field="foodate">04/02/02</value>
+        <value field="color">white</value>
+        <value field="foobs">40</value>
+      </row>
+      <row>
+        <value field="id">10</value>
+        <value field="name">Candy</value>
+        <value field="foodate">04/03/02</value>
+        <value field="color">white</value>
+        <value field="foobs">11</value>
+      </row>
+      <row>
+        <value field="id">11</value>
+        <value field="name">Candy</value>
+        <value field="foodate">04/04/02</value>
+        <value field="color">white</value>
+        <value field="foobs">33</value>
+      </row>
+      <row>
+        <value field="id">12</value>
+        <value field="name">Candy</value>
+        <value field="foodate">04/01/02</value>
+        <value field="color">black</value>
+        <value field="foobs">305</value>
+      </row>
+      <row>
+        <value field="id">13</value>
+        <value field="name">Candy</value>
+        <value field="foodate">04/02/02</value>
+        <value field="color">black</value>
+        <value field="foobs">403</value>
+      </row>
+      <row>
+        <value field="id">14</value>
+        <value field="name">Sandy</value>
+        <value field="foodate">04/02/02</value>
+        <value field="color">black</value>
+        <value field="foobs">-5003</value>
+      </row>
+    </rows>
+  </tabledata>
+</data>
+</schema>