<!DOCTYPE openRPTDef>
<report>
 <title>Financial Trend</title>
 <name>FinancialTrend</name>
 <description>Financial Trend Report</description>
 <parameter default="" active="false" listtype="dynamic" type="integer" name="flhead_id">
  <description>Financial Report Layout</description>
  <query>SELECT flhead_id, flhead_name FROM flhead WHERE (flhead_active)</query>
 </parameter>
 <parameter default="M" active="true" listtype="static" type="string" name="interval">
  <description>Time period buckets</description>
  <item value="M">Month</item>
  <item value="Q">Quarter</item>
  <item value="Y">Year</item>
 </parameter>
 <parameter default="" active="true" listtype="dynamic" type="integer" name="period_id_list">
  <description>Accounting Period Reference</description>
  <query>SELECT period_id, 
  CASE
    WHEN period_name &lt;> '' THEN period_name 
    ELSE (formatdate(period_start) || '-' || formatdate(period_end)) 
  END 
FROM period 
ORDER BY period_end DESC</query>
 </parameter>
 <parameter default="true" active="false" listtype="static" type="bool" name="shownumbers">
  <description>Display account numbers with description</description>
 </parameter>
 <grid>
  <snap/>
  <show/>
  <x>0.05</x>
  <y>0.05</y>
 </grid>
 <size>Letter</size>
 <landscape/>
 <topmargin>50</topmargin>
 <bottommargin>50</bottommargin>
 <rightmargin>25</rightmargin>
 <leftmargin>25</leftmargin>
 <querysource>
  <name>head</name>
  <sql>SELECT 
    &lt;? value("project") ?> AS project,
    (SELECT prj_name FROM prj WHERE prj_id=&lt;? value("prj_id") ?>) AS prj_name,
    fltrendhead_username,
    fltrendhead_flhead_name,
    fltrendhead_typedescrip,
    fltrendhead_fld1,
    fltrendhead_fld2,
    fltrendhead_fld3,
    fltrendhead_fld4,
    fltrendhead_fld5,
    fltrendhead_fld6,
    fltrendhead_fld7,
    fltrendhead_fld8,
    fltrendhead_fld9,
    fltrendhead_fld10,
    fltrendhead_fld11,
    fltrendhead_fld12,
    fltrendhead_grndttl
FROM getfltrendhead(&lt;? value("flhead_id") ?>,ARRAY[
   &lt;? foreach("period_id_list") ?>
     &lt;? if not isfirst("period_id_list") ?>
      ,
     &lt;? endif ?>
    &lt;? value("period_id_list") ?>
   &lt;? endforeach ?>
],&lt;? value("interval") ?>)</sql>
 </querysource>
 <querysource>
  <name>detail</name>
  <sql>SELECT 
    fltrenditem_flhead_id,
    fltrenditem_username,
    fltrenditem_order,
    fltrenditem_level,
    fltrenditem_subgrp,
    fltrenditem_type,
    fltrenditem_type_id,
    fltrenditem_parent_id,
    fltrenditem_accnt_id,
    fltrenditem_name,
    fltrenditem_fld1,
    fltrenditem_fld2,
    fltrenditem_fld3,
    fltrenditem_fld4,
    fltrenditem_fld5,
    fltrenditem_fld6,
    fltrenditem_fld7,
    fltrenditem_fld8,
    fltrenditem_fld9,
    fltrenditem_fld10,
    fltrenditem_fld11,
    fltrenditem_fld12,
    fltrenditem_grndttl
FROM
   financialReport(&lt;? value("flhead_id") ?>, ARRAY[
   &lt;? foreach("period_id_list") ?>
     &lt;? if not isfirst("period_id_list") ?>
      ,
     &lt;? endif ?>
    &lt;? value("period_id_list") ?>
   &lt;? endforeach ?>
],&lt;? value("interval") ?>,
&lt;? if exists("shownumbers") ?>
  true
&lt;? else ?>
  false
&lt;? endif ?>
,&lt;? value("prj_id") ?>)
&lt;? if not exists("showzeros") ?>
  WHERE ((fltrenditem_fld1 &lt;> formatMoney(0) AND fltrenditem_fld1 IS NOT NULL) 
	OR (fltrenditem_fld1 &lt;> formatMoney(0) AND fltrenditem_fld1 IS NOT NULL)
	OR (fltrenditem_fld2 &lt;> formatMoney(0) AND fltrenditem_fld2 IS NOT NULL)
	OR (fltrenditem_fld3 &lt;> formatMoney(0) AND fltrenditem_fld3 IS NOT NULL)
	OR (fltrenditem_fld4 &lt;> formatMoney(0) AND fltrenditem_fld4 IS NOT NULL)
	OR (fltrenditem_fld5 &lt;> formatMoney(0) AND fltrenditem_fld5 IS NOT NULL)
	OR (fltrenditem_fld6 &lt;> formatMoney(0) AND fltrenditem_fld6 IS NOT NULL)
	OR (fltrenditem_fld7 &lt;> formatMoney(0) AND fltrenditem_fld7 IS NOT NULL)
	OR (fltrenditem_fld8 &lt;> formatMoney(0) AND fltrenditem_fld8 IS NOT NULL)
	OR (fltrenditem_fld9 &lt;> formatMoney(0) AND fltrenditem_fld9 IS NOT NULL)
	OR (fltrenditem_fld10 &lt;> formatMoney(0) AND fltrenditem_fld10 IS NOT NULL)
	OR (fltrenditem_fld11 &lt;> formatMoney(0) AND fltrenditem_fld11 IS NOT NULL)
	OR (fltrenditem_fld12 &lt;> formatMoney(0) AND fltrenditem_fld12 IS NOT NULL)
	OR (fltrenditem_type &lt;> 'I'))
&lt;? endif ?></sql>
 </querysource>
 <querysource>
  <name>notes</name>
  <sql>SELECT * FROM (
SELECT 1 AS seq, text('Notes') AS label, flhead_notes AS notes, 
  startOfTime() AS period_end
FROM flhead
WHERE ((flhead_id=&lt;? value("flhead_id") ?>)
  AND (length(flhead_notes) > 0))
UNION ALL
SELECT 2 AS seq, period_name AS label, flnotes_notes AS notes, 
  period_end
FROM flnotes
  JOIN period ON (flnotes_period_id=period_id)
WHERE ((flnotes_flhead_id=&lt;? value("flhead_id") ?>)
  AND (
   &lt;? foreach("period_id_list") ?>
     &lt;? if not isfirst("period_id_list") ?>
      OR 
     &lt;? endif ?>
    (flnotes_period_id=&lt;? value("period_id_list") ?>)
   &lt;? endforeach ?>
  )
  AND (length(flnotes_notes) > 0))) data
ORDER BY seq, period_end;
</sql>
 </querysource>
 <rpthead>
  <height>149</height>
  <field>
   <rect>
    <x>208</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld1</column>
   </data>
  </field>
  <field>
   <rect>
    <x>100</x>
    <y>60</y>
    <width>459</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_flhead_name</column>
   </data>
  </field>
  <field>
   <rect>
    <x>860</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld11</column>
   </data>
  </field>
  <field>
   <rect>
    <x>918</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld12</column>
   </data>
  </field>
  <field>
   <rect>
    <x>469</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld5</column>
   </data>
  </field>
  <field>
   <rect>
    <x>405</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld4</column>
   </data>
  </field>
  <field>
   <rect>
    <x>600</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld7</column>
   </data>
  </field>
  <label>
   <rect>
    <x>20</x>
    <y>80</y>
    <width>80</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Type:</string>
  </label>
  <field>
   <rect>
    <x>275</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld2</column>
   </data>
  </field>
  <field>
   <rect>
    <x>795</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld10</column>
   </data>
  </field>
  <line>
   <xstart>5</xstart>
   <ystart>135</ystart>
   <xend>1050</xend>
   <yend>135</yend>
   <weight>2</weight>
  </line>
  <field>
   <rect>
    <x>535</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld6</column>
   </data>
  </field>
  <field>
   <rect>
    <x>665</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld8</column>
   </data>
  </field>
  <field>
   <rect>
    <x>104</x>
    <y>80</y>
    <width>459</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_typedescrip</column>
   </data>
  </field>
  <label>
   <rect>
    <x>5</x>
    <y>120</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Name</string>
  </label>
  <field>
   <rect>
    <x>989</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_grndttl</column>
   </data>
  </field>
  <label>
   <rect>
    <x>640</x>
    <y>10</y>
    <width>350</width>
    <height>37</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Financial Trend</string>
  </label>
  <label>
   <rect>
    <x>20</x>
    <y>60</y>
    <width>80</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Name:</string>
  </label>
  <field>
   <rect>
    <x>340</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld3</column>
   </data>
  </field>
  <field>
   <rect>
    <x>730</x>
    <y>120</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld9</column>
   </data>
  </field>
  <field>
   <rect>
    <x>100</x>
    <y>40</y>
    <width>459</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>prj_name</column>
   </data>
  </field>
  <field>
   <rect>
    <x>20</x>
    <y>40</y>
    <width>80</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>project</column>
   </data>
  </field>
 </rpthead>
 <pghead>
  <firstpage/>
  <height>10</height>
 </pghead>
 <pghead>
  <height>43</height>
  <field>
   <rect>
    <x>208</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld1</column>
   </data>
  </field>
  <field>
   <rect>
    <x>340</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld3</column>
   </data>
  </field>
  <field>
   <rect>
    <x>665</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld8</column>
   </data>
  </field>
  <field>
   <rect>
    <x>600</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld7</column>
   </data>
  </field>
  <field>
   <rect>
    <x>535</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld6</column>
   </data>
  </field>
  <line>
   <xstart>5</xstart>
   <ystart>30</ystart>
   <xend>1050</xend>
   <yend>30</yend>
   <weight>2</weight>
  </line>
  <field>
   <rect>
    <x>405</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld4</column>
   </data>
  </field>
  <field>
   <rect>
    <x>730</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld9</column>
   </data>
  </field>
  <field>
   <rect>
    <x>795</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld10</column>
   </data>
  </field>
  <field>
   <rect>
    <x>918</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld12</column>
   </data>
  </field>
  <field>
   <rect>
    <x>860</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld11</column>
   </data>
  </field>
  <field>
   <rect>
    <x>280</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld2</column>
   </data>
  </field>
  <field>
   <rect>
    <x>469</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_fld5</column>
   </data>
  </field>
  <field>
   <rect>
    <x>985</x>
    <y>10</y>
    <width>60</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>fltrendhead_grndttl</column>
   </data>
  </field>
  <label>
   <rect>
    <x>0</x>
    <y>8.5</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Name</string>
  </label>
 </pghead>
 <section>
  <name>detail</name>
  <group>
   <name>subgrp</name>
   <column>fltrenditem_subgrp</column>
   <foot>
    <height>7</height>
    <line>
     <xstart>204</xstart>
     <ystart>0</ystart>
     <xend>1055</xend>
     <yend>0</yend>
     <weight>1</weight>
    </line>
   </foot>
  </group>
  <detail>
   <key>
    <query>detail</query>
   </key>
   <height>19</height>
   <field>
    <rect>
     <x>925</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld12</column>
    </data>
   </field>
   <field>
    <rect>
     <x>665</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld8</column>
    </data>
   </field>
   <field>
    <rect>
     <x>340</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld3</column>
    </data>
   </field>
   <field>
    <rect>
     <x>469</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld5</column>
    </data>
   </field>
   <field>
    <rect>
     <x>860</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld11</column>
    </data>
   </field>
   <field>
    <rect>
     <x>600</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld7</column>
    </data>
   </field>
   <field>
    <rect>
     <x>535</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld6</column>
    </data>
   </field>
   <field>
    <rect>
     <x>405</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld4</column>
    </data>
   </field>
   <field>
    <rect>
     <x>730</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld9</column>
    </data>
   </field>
   <field>
    <rect>
     <x>208</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld1</column>
    </data>
   </field>
   <field>
    <rect>
     <x>795</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld10</column>
    </data>
   </field>
   <field>
    <rect>
     <x>989</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_grndttl</column>
    </data>
   </field>
   <field>
    <rect>
     <x>5</x>
     <y>0</y>
     <width>195</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_name</column>
    </data>
   </field>
   <field>
    <rect>
     <x>275</x>
     <y>0</y>
     <width>60</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>fltrenditem_fld2</column>
    </data>
   </field>
  </detail>
 </section>
 <section>
  <name>notes</name>
  <detail>
   <key>
    <query>notes</query>
   </key>
   <height>32</height>
   <text>
    <rect>
     <x>10</x>
     <y>17</y>
     <width>1025</width>
     <height>15</height>
    </rect>
    <bottompad>0</bottompad>
    <font>
     <face>Arial</face>
     <size>9</size>
     <weight>normal</weight>
    </font>
    <left/>
    <top/>
    <data>
     <query>notes</query>
     <column>notes</column>
    </data>
   </text>
   <field>
    <rect>
     <x>5</x>
     <y>2</y>
     <width>500</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>9</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>notes</query>
     <column>label</column>
    </data>
   </field>
  </detail>
 </section>
 <pgfoot>
  <height>29</height>
  <label>
   <rect>
    <x>839</x>
    <y>0</y>
    <width>85</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Page:</string>
  </label>
  <label>
   <rect>
    <x>5</x>
    <y>0</y>
    <width>85</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Report Date:</string>
  </label>
  <field>
   <rect>
    <x>95</x>
    <y>0</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Context Query</query>
    <column>report_date</column>
   </data>
  </field>
  <field>
   <rect>
    <x>930</x>
    <y>0</y>
    <width>40</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Context Query</query>
    <column>page_number</column>
   </data>
  </field>
 </pgfoot>
</report>
