<!DOCTYPE openRPTDef>
<report>
 <title>Single Level Bill of Materials</title>
 <name>SingleLevelBOM</name>
 <description></description>
 <size>Letter</size>
 <portrait/>
 <topmargin>50</topmargin>
 <bottommargin>50</bottommargin>
 <rightmargin>50</rightmargin>
 <leftmargin>50</leftmargin>
 <querysource>
  <name>head</name>
  <sql>SELECT item_number, uom_name AS item_invuom, item_descrip1, item_descrip2
FROM item, uom
WHERE ((item_id=&lt;? value("item_id") ?>)
AND (item_inv_uom_id=uom_id));
    </sql>
 </querysource>
 <querysource>
  <name>detail</name>
  <sql>SELECT bomitem_seqnumber, item_number,
       invuom.uom_name AS invuomname, issueuom.uom_name AS issueuomname,
       item_descrip1, item_descrip2,
       formatBoolYN(bomitem_createwo) AS createchild,
       CASE WHEN (bomitem_issuemethod='S') THEN 'Push'
            WHEN (bomitem_issuemethod='L') THEN 'Pull'
            WHEN (bomitem_issuemethod='M') THEN 'Mixed'
            ELSE 'Special'
       END AS issuemethod,
       formatQty(bomitem_qtyfxd) AS issueqtyfxd,
       formatQty(itemuomtouom(bomitem_item_id, bomitem_uom_id, NULL, bomitem_qtyfxd)) AS invqtyfxd,
       formatQtyPer(bomitem_qtyper) AS issueqtyper,
       formatQtyPer(itemuomtouom(bomitem_item_id, bomitem_uom_id, NULL, bomitem_qtyper)) AS invqtyper,
       formatScrap(bomitem_scrap) AS scrap,
       formatQtyPer((bomitem_qtyfxd + bomitem_qtyper) * (1 + bomitem_scrap)) AS qtyreq,
       formatDate(bomitem_effective, &lt;? value("always") ?>) AS effective,
       formatDate(bomitem_expires, &lt;? value("never") ?>) AS expires,
       bomitem_ecn
&lt;? if exists("revision_id") ?>
  FROM bomitem(&lt;? value("item_id") ?>,&lt;? value("revision_id") ?>)
&lt;? else ?>
  FROM bomitem(&lt;? value("item_id") ?>)
&lt;? endif ?>
, item, uom AS issueuom, uom AS invuom
WHERE ((bomitem_item_id=item_id)
AND (item_inv_uom_id=invuom.uom_id)
AND (bomitem_uom_id=issueuom.uom_id)
&lt;? if exists("expiredDays") ?>
 AND (bomitem_expires > (CURRENT_DATE - &lt;? value("expiredDays") ?>))
&lt;? else ?>
 AND (bomitem_expires > CURRENT_DATE)
&lt;? endif ?>

&lt;? if exists("effectiveDays") ?>
 AND (bomitem_effective &lt;= (CURRENT_DATE + &lt;? value("effectiveDays") ?>))
&lt;? else ?>
 AND (bomitem_effective &lt;= CURRENT_DATE)
&lt;? endif ?>

)
ORDER BY bomitem_seqnumber, bomitem_effective;
</sql>
 </querysource>
 <querysource>
  <name>bomhead</name>
  <sql>SELECT bomhead_docnum, bomhead_revision,
       formatDate(bomhead_revisiondate) AS f_revisiondate
FROM bomhead
WHERE ((bomhead_item_id=&lt;? value("item_id") ?>)
&lt;? if exists("revision_id") ?>
AND (bomhead_rev_id=&lt;? value("revision_id") ?>)
&lt;? else ?>
AND (bomhead_rev_id=getActiveRevId('BOM',&lt;? value("item_id") ?>))
&lt;? endif ?>
);</sql>
 </querysource>
 <rpthead>
  <height>208</height>
  <label>
   <rect>
    <x>600</x>
    <y>175</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Effective</string>
  </label>
  <label>
   <rect>
    <x>395</x>
    <y>176</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue UOM</string>
  </label>
  <field>
   <rect>
    <x>120</x>
    <y>110</y>
    <width>300</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>item_descrip1</column>
   </data>
  </field>
  <label>
   <rect>
    <x>35</x>
    <y>90</y>
    <width>80</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Item:</string>
  </label>
  <label>
   <rect>
    <x>70</x>
    <y>190</y>
    <width>130</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Description</string>
  </label>
  <label>
   <rect>
    <x>15</x>
    <y>175</y>
    <width>50</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Seq. #</string>
  </label>
  <label>
   <rect>
    <x>470</x>
    <y>186</y>
    <width>40</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>ECN #</string>
  </label>
  <field>
   <rect>
    <x>482</x>
    <y>130</y>
    <width>200</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>bomhead</query>
    <column>bomhead_revision</column>
   </data>
  </field>
  <label>
   <rect>
    <x>675</x>
    <y>186</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue Method</string>
  </label>
  <label>
   <rect>
    <x>525</x>
    <y>175</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Qty. Required</string>
  </label>
  <label>
   <rect>
    <x>380</x>
    <y>90</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Document #:</string>
  </label>
  <label>
   <rect>
    <x>380</x>
    <y>110</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Revision Date:</string>
  </label>
  <label>
   <rect>
    <x>675</x>
    <y>175</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Expires</string>
  </label>
  <label>
   <rect>
    <x>70</x>
    <y>175</y>
    <width>227</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Component Item Number</string>
  </label>
  <field>
   <rect>
    <x>120</x>
    <y>90</y>
    <width>200</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>item_number</column>
   </data>
  </field>
  <label>
   <rect>
    <x>600</x>
    <y>186</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Create W/O</string>
  </label>
  <label>
   <rect>
    <x>442</x>
    <y>175</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Scrap</string>
  </label>
  <label>
   <rect>
    <x>380</x>
    <y>130</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Revision:</string>
  </label>
  <field>
   <rect>
    <x>482</x>
    <y>110</y>
    <width>200</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>bomhead</query>
    <column>f_revisiondate</column>
   </data>
  </field>
  <field>
   <rect>
    <x>482</x>
    <y>90</y>
    <width>200</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>bomhead</query>
    <column>bomhead_docnum</column>
   </data>
  </field>
  <label>
   <rect>
    <x>320</x>
    <y>186</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Inv. Qty. Per</string>
  </label>
  <label>
   <rect>
    <x>375</x>
    <y>16</y>
    <width>350</width>
    <height>40</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Single Level Bill of Materials</string>
  </label>
  <field>
   <rect>
    <x>120</x>
    <y>130</y>
    <width>300</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>item_descrip2</column>
   </data>
  </field>
  <line>
   <xstart>5</xstart>
   <ystart>202</ystart>
   <xend>745</xend>
   <yend>202</yend>
   <weight>2</weight>
  </line>
  <label>
   <rect>
    <x>320</x>
    <y>176</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue Qty. Per</string>
  </label>
  <label>
   <rect>
    <x>395</x>
    <y>186</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Inv. UOM</string>
  </label>
  <label>
   <rect>
    <x>235</x>
    <y>176</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue Fxd. Qty.</string>
  </label>
  <label>
   <rect>
    <x>235</x>
    <y>186</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Inv. Fxd. Qty.</string>
  </label>
 </rpthead>
 <pghead>
  <firstpage/>
  <height>7</height>
 </pghead>
 <pghead>
  <height>37</height>
  <label>
   <rect>
    <x>675</x>
    <y>0</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Expires</string>
  </label>
  <label>
   <rect>
    <x>470</x>
    <y>13</y>
    <width>40</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>ECN #</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>0</y>
    <width>50</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Seq. #</string>
  </label>
  <label>
   <rect>
    <x>600</x>
    <y>13</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Create W/O</string>
  </label>
  <label>
   <rect>
    <x>600</x>
    <y>0</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Effective</string>
  </label>
  <label>
   <rect>
    <x>525</x>
    <y>0</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Qty. Required</string>
  </label>
  <label>
   <rect>
    <x>400</x>
    <y>13</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Inv. UOM</string>
  </label>
  <label>
   <rect>
    <x>675</x>
    <y>13</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue Method</string>
  </label>
  <label>
   <rect>
    <x>442</x>
    <y>0</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Scrap</string>
  </label>
  <label>
   <rect>
    <x>70</x>
    <y>0</y>
    <width>95</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Component Item Number</string>
  </label>
  <label>
   <rect>
    <x>70</x>
    <y>15</y>
    <width>95</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Description</string>
  </label>
  <line>
   <xstart>5</xstart>
   <ystart>30</ystart>
   <xend>745</xend>
   <yend>30</yend>
   <weight>2</weight>
  </line>
  <label>
   <rect>
    <x>320</x>
    <y>13</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Inv. Qty. Per</string>
  </label>
  <label>
   <rect>
    <x>320</x>
    <y>-2</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue Qty. Per</string>
  </label>
  <label>
   <rect>
    <x>400</x>
    <y>-2</y>
    <width>55</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue UOM</string>
  </label>
  <label>
   <rect>
    <x>250</x>
    <y>-2</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue Fxd. Qty.</string>
  </label>
  <label>
   <rect>
    <x>250</x>
    <y>13</y>
    <width>75</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Inv. Fxd. Qty.</string>
  </label>
 </pghead>
 <section>
  <name>detail</name>
  <detail>
   <key>
    <query>detail</query>
   </key>
   <height>57</height>
   <field>
    <rect>
     <x>405</x>
     <y>18</y>
     <width>37</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>invuomname</column>
    </data>
   </field>
   <field>
    <rect>
     <x>675</x>
     <y>18</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>issuemethod</column>
    </data>
   </field>
   <field>
    <rect>
     <x>675</x>
     <y>3</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>expires</column>
    </data>
   </field>
   <field>
    <rect>
     <x>440</x>
     <y>3</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>scrap</column>
    </data>
   </field>
   <field>
    <rect>
     <x>15</x>
     <y>0</y>
     <width>40</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>bomitem_seqnumber</column>
    </data>
   </field>
   <field>
    <rect>
     <x>315</x>
     <y>33</y>
     <width>227</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_descrip2</column>
    </data>
   </field>
   <field>
    <rect>
     <x>315</x>
     <y>18</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>invqtyper</column>
    </data>
   </field>
   <field>
    <rect>
     <x>70</x>
     <y>0</y>
     <width>115</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_number</column>
    </data>
   </field>
   <line>
    <xstart>5</xstart>
    <ystart>45</ystart>
    <xend>745</xend>
    <yend>45</yend>
    <weight>0</weight>
   </line>
   <field>
    <rect>
     <x>600</x>
     <y>3</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>effective</column>
    </data>
   </field>
   <field>
    <rect>
     <x>455</x>
     <y>18</y>
     <width>135</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>bomitem_ecn</column>
    </data>
   </field>
   <field>
    <rect>
     <x>525</x>
     <y>3</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>qtyreq</column>
    </data>
   </field>
   <field>
    <rect>
     <x>600</x>
     <y>18</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>createchild</column>
    </data>
   </field>
   <field>
    <rect>
     <x>70</x>
     <y>33</y>
     <width>227</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_descrip1</column>
    </data>
   </field>
   <field>
    <rect>
     <x>315</x>
     <y>3</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>issueqtyper</column>
    </data>
   </field>
   <field>
    <rect>
     <x>405</x>
     <y>3</y>
     <width>37</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>issueuomname</column>
    </data>
   </field>
   <field>
    <rect>
     <x>235</x>
     <y>3</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>issueqtyfxd</column>
    </data>
   </field>
   <field>
    <rect>
     <x>235</x>
     <y>18</y>
     <width>75</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>invqtyfxd</column>
    </data>
   </field>
  </detail>
 </section>
 <pgfoot>
  <height>21</height>
  <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>705</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>
  <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>
  <label>
   <rect>
    <x>615</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>
 </pgfoot>
</report>
