<!DOCTYPE openRPTDef>
<report>
 <title>Sales Order Acknowledgement</title>
 <name>SalesOrderAcknowledgement</name>
 <description>Sales Order Acknowledgement Omits Closed Lines -- With Barcodes formatitemsitebarcode(itemsite_id) -- SO # barcoded formatsobarcode(cohead_id) -- With Logo, place logo graphic in images DB with name "logo"</description>
 <grid>
  <snap/>
  <show/>
  <x>0.05</x>
  <y>0.05</y>
 </grid>
 <size>Letter</size>
 <portrait/>
 <topmargin>25</topmargin>
 <bottommargin>25</bottommargin>
 <rightmargin>25</rightmargin>
 <leftmargin>25</leftmargin>
 <querysource>
  <name>head</name>
  <sql>SELECT cust_number,
       formatsobarcode(cohead_id) AS order_barcode,

       formataddr(cohead_billtoaddress1, cohead_billtoaddress2, cohead_billtoaddress3, (cohead_billtocity || '  ' ||   cohead_billtostate || '  ' || cohead_billtozipcode), cohead_billtocountry) AS billing_address, 

  formataddr(cohead_shiptoaddress1, cohead_shiptoaddress2, cohead_shiptoaddress3, (cohead_shiptocity || '  ' ||   cohead_shiptostate || '  ' || cohead_shiptozipcode), cohead_shiptocountry) AS shipping_address,           

       trim(cntct_first_name || ' ' || cntct_last_name) AS cust_contact,
       cohead_billtoname,
       cohead_billtoaddress1,
       cohead_billtoaddress2,
       cohead_billtoaddress3,
       (cohead_billtocity || '  ' || cohead_billtostate || '  ' || cohead_billtozipcode) AS billtocitystatezip,
       cntct_phone AS cust_phone,
       cohead_shiptoname,
       cohead_shiptoaddress1,
       cohead_shiptoaddress2,
       cohead_shiptoaddress3,
       (cohead_shiptocity || '  ' || cohead_shiptostate || ' ' || cohead_shiptozipcode) AS shiptocitystatezip,
       cohead_number,
       cohead_shipvia,
       cohead_shiptophone,
       cohead_custponumber,
       formatDate(cohead_orderdate) AS orderdate,
       cohead_shipcomments, 
       terms_descrip
  FROM cohead, custinfo, terms, cntct
 WHERE ((cohead_cust_id=cust_id)
   AND (cust_cntct_id=cntct_id)
   AND (cohead_terms_id=terms_id)
   AND (cohead_id=&lt;? value("sohead_id") ?>)
);</sql>
 </querysource>
 <querysource>
  <name>scheddate</name>
  <sql>SELECT formatDate(MIN(coitem_scheddate)) AS scheddate
  FROM coitem
 WHERE ((coitem_status &lt;> 'X') AND (coitem_cohead_id=&lt;? value("sohead_id") ?>));</sql>
 </querysource>
 <querysource loadFromDb="true">
  <name>detail</name>
  <mqlgroup>salesOrderItems</mqlgroup>
  <mqlname>list</mqlname>
 </querysource>
 <querysource>
  <name>logo</name>
  <sql>SELECT image_data 
FROM image 
WHERE ((image_name='logo'));</sql>
 </querysource>
 <rpthead>
  <height>477</height>
  <image>
   <rect>
    <x>375</x>
    <y>0</y>
    <width>425</width>
    <height>85</height>
   </rect>
   <mode>stretch</mode>
   <data>
    <query>logo</query>
    <column>image_data</column>
   </data>
  </image>
  <field>
   <rect>
    <x>120</x>
    <y>400</y>
    <width>253</width>
    <height>25</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>12</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>head</query>
    <column>cust_contact</column>
   </data>
  </field>
  <label>
   <rect>
    <x>365</x>
    <y>400</y>
    <width>75</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>12</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Terms:</string>
  </label>
  <field>
   <rect>
    <x>175</x>
    <y>195</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>orderdate</column>
   </data>
  </field>
  <label>
   <rect>
    <x>330</x>
    <y>215</y>
    <width>102</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Ship Via:</string>
  </label>
  <field>
   <rect>
    <x>469</x>
    <y>400</y>
    <width>320</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>12</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>terms_descrip</column>
   </data>
  </field>
  <label>
   <rect>
    <x>25</x>
    <y>444</y>
    <width>95</width>
    <height>13</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>8</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Description</string>
  </label>
  <barcode>
   <rect>
    <x>375</x>
    <y>130</y>
    <width>177</width>
    <height>25</height>
   </rect>
   <format>3of9</format>
   <maxlength>10</maxlength>
   <left/>
   <narrowBarWidth>0.01</narrowBarWidth>
   <data>
    <query>head</query>
    <column>cust_number</column>
   </data>
  </barcode>
  <barcode>
   <rect>
    <x>375</x>
    <y>160</y>
    <width>307</width>
    <height>25</height>
   </rect>
   <format>3of9</format>
   <maxlength>20</maxlength>
   <left/>
   <narrowBarWidth>0.01</narrowBarWidth>
   <data>
    <query>head</query>
    <column>cohead_custponumber</column>
   </data>
  </barcode>
  <label>
   <rect>
    <x>440</x>
    <y>425</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Shipped</string>
  </label>
  <field>
   <rect>
    <x>170</x>
    <y>155</y>
    <width>170</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>cohead_custponumber</column>
   </data>
  </field>
  <label>
   <rect>
    <x>50</x>
    <y>215</y>
    <width>121</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Sched. Date:</string>
  </label>
  <label>
   <rect>
    <x>545</x>
    <y>425</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Balance</string>
  </label>
  <field>
   <rect>
    <x>433</x>
    <y>215</y>
    <width>331</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>cohead_shipvia</column>
   </data>
  </field>
  <label>
   <rect>
    <x>650</x>
    <y>425</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>At Shipping</string>
  </label>
  <field>
   <rect>
    <x>170</x>
    <y>95</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>cohead_number</column>
   </data>
  </field>
  <barcode>
   <rect>
    <x>375</x>
    <y>95</y>
    <width>234</width>
    <height>25</height>
   </rect>
   <format>128</format>
   <maxlength>10</maxlength>
   <left/>
   <narrowBarWidth>0.01</narrowBarWidth>
   <data>
    <query>head</query>
    <column>order_barcode</column>
   </data>
  </barcode>
  <label>
   <rect>
    <x>10</x>
    <y>5</y>
    <width>365</width>
    <height>40</height>
   </rect>
   <font>
    <face>Helvetica</face>
    <size>16</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Sales Order Acknowledgement</string>
  </label>
  <line>
   <xstart>25</xstart>
   <ystart>465</ystart>
   <xend>823</xend>
   <yend>465</yend>
   <weight>0</weight>
  </line>
  <label>
   <rect>
    <x>15</x>
    <y>155</y>
    <width>150</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Customer P/O #:</string>
  </label>
  <field>
   <rect>
    <x>75</x>
    <y>260</y>
    <width>305</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>cohead_billtoname</column>
   </data>
  </field>
  <text>
   <rect>
    <x>75</x>
    <y>280</y>
    <width>295</width>
    <height>20</height>
   </rect>
   <bottompad>10</bottompad>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>head</query>
    <column>billing_address</column>
   </data>
  </text>
  <label>
   <rect>
    <x>385</x>
    <y>260</y>
    <width>75</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Ship To:</string>
  </label>
  <label>
   <rect>
    <x>25</x>
    <y>400</y>
    <width>95</width>
    <height>25</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>12</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <string>Attention:</string>
  </label>
  <label>
   <rect>
    <x>745</x>
    <y>425</y>
    <width>55</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Packed</string>
  </label>
  <text>
   <rect>
    <x>465</x>
    <y>280</y>
    <width>305</width>
    <height>20</height>
   </rect>
   <bottompad>10</bottompad>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>head</query>
    <column>shipping_address</column>
   </data>
  </text>
  <field>
   <rect>
    <x>170</x>
    <y>125</y>
    <width>170</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>cust_number</column>
   </data>
  </field>
  <label>
   <rect>
    <x>10</x>
    <y>260</y>
    <width>65</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Bill To:</string>
  </label>
  <label>
   <rect>
    <x>25</x>
    <y>425</y>
    <width>85</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Item Number</string>
  </label>
  <field>
   <rect>
    <x>465</x>
    <y>260</y>
    <width>305</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>cohead_shiptoname</column>
   </data>
  </field>
  <label>
   <rect>
    <x>340</x>
    <y>425</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Ordered</string>
  </label>
  <field>
   <rect>
    <x>175</x>
    <y>215</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>scheddate</query>
    <column>scheddate</column>
   </data>
  </field>
  <line>
   <xstart>25</xstart>
   <ystart>425</ystart>
   <xend>823</xend>
   <yend>425</yend>
   <weight>0</weight>
  </line>
  <label>
   <rect>
    <x>70</x>
    <y>195</y>
    <width>102</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>S/O Date:</string>
  </label>
  <label>
   <rect>
    <x>253</x>
    <y>425</y>
    <width>35</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>UOM</string>
  </label>
  <label>
   <rect>
    <x>15</x>
    <y>95</y>
    <width>60</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>S/O #:</string>
  </label>
  <label>
   <rect>
    <x>15</x>
    <y>125</y>
    <width>122</width>
    <height>20</height>
   </rect>
   <font>
    <face>helvetica</face>
    <size>14</size>
    <weight>normal</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Customer #:</string>
  </label>
 </rpthead>
 <section>
  <name>detail</name>
  <group>
   <name>detail</name>
   <column>groupby</column>
   <foot>
    <height>72</height>
    <text>
     <rect>
      <x>50</x>
      <y>5</y>
      <width>625</width>
      <height>17</height>
     </rect>
     <bottompad>14</bottompad>
     <font>
      <face>helvetica</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <data>
      <query>head</query>
      <column>cohead_shipcomments</column>
     </data>
    </text>
   </foot>
  </group>
  <group>
   <name>lineitem</name>
   <column>coitem_linenumber</column>
   <foot>
    <height>28</height>
    <line>
     <xstart>5</xstart>
     <ystart>5</ystart>
     <xend>843</xend>
     <yend>5</yend>
     <weight>0</weight>
    </line>
   </foot>
  </group>
  <detail>
   <key>
    <query>detail</query>
   </key>
   <height>153</height>
   <field>
    <rect>
     <x>425</x>
     <y>0</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>helvetica</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>f_qtyshipped</column>
    </data>
   </field>
   <field>
    <rect>
     <x>635</x>
     <y>0</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>helvetica</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>f_qtyatshipping</column>
    </data>
   </field>
   <barcode>
    <rect>
     <x>365</x>
     <y>30</y>
     <width>469</width>
     <height>35</height>
    </rect>
    <format>128</format>
    <maxlength>15</maxlength>
    <left/>
    <narrowBarWidth>0.01</narrowBarWidth>
    <data>
     <query>detail</query>
     <column>item_barcode</column>
    </data>
   </barcode>
   <field>
    <rect>
     <x>630</x>
     <y>95</y>
     <width>85</width>
     <height>15</height>
    </rect>
    <font>
     <face>helvetica</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>enhanced_status</column>
    </data>
   </field>
   <text>
    <rect>
     <x>100</x>
     <y>120</y>
     <width>700</width>
     <height>17</height>
    </rect>
    <bottompad>14</bottompad>
    <font>
     <face>helvetica</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>coitem_memo</column>
    </data>
   </text>
   <line>
    <xstart>80</xstart>
    <ystart>80</ystart>
    <xend>170</xend>
    <yend>80</yend>
    <weight>0</weight>
   </line>
   <label>
    <rect>
     <x>25</x>
     <y>95</y>
     <width>48</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Qty:</string>
   </label>
   <label>
    <rect>
     <x>20</x>
     <y>120</y>
     <width>75</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Notes:</string>
   </label>
   <line>
    <xstart>415</xstart>
    <ystart>80</ystart>
    <xend>500</xend>
    <yend>80</yend>
    <weight>0</weight>
   </line>
   <label>
    <rect>
     <x>565</x>
     <y>70</y>
     <width>60</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <top/>
    <string>Batch #:</string>
   </label>
   <field>
    <rect>
     <x>530</x>
     <y>0</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>helvetica</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>f_balance</column>
    </data>
   </field>
   <label>
    <rect>
     <x>25</x>
     <y>65</y>
     <width>48</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Carton:</string>
   </label>
   <line>
    <xstart>80</xstart>
    <ystart>110</ystart>
    <xend>170</xend>
    <yend>110</yend>
    <weight>0</weight>
   </line>
   <field>
    <rect>
     <x>25</x>
     <y>40</y>
     <width>295</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>11</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_descrip2_cust</column>
    </data>
   </field>
   <line>
    <xstart>305</xstart>
    <ystart>110</ystart>
    <xend>395</xend>
    <yend>110</yend>
    <weight>0</weight>
   </line>
   <field>
    <rect>
     <x>25</x>
     <y>0</y>
     <width>200</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>11</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_number_cust</column>
    </data>
   </field>
   <field>
    <rect>
     <x>25</x>
     <y>20</y>
     <width>295</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>11</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_descrip1_cust</column>
    </data>
   </field>
   <line>
    <xstart>745</xstart>
    <ystart>15</ystart>
    <xend>795</xend>
    <yend>15</yend>
    <weight>1</weight>
   </line>
   <line>
    <xstart>190</xstart>
    <ystart>80</ystart>
    <xend>280</xend>
    <yend>80</yend>
    <weight>0</weight>
   </line>
   <line>
    <xstart>632</xstart>
    <ystart>80</ystart>
    <xend>720</xend>
    <yend>80</yend>
    <weight>0</weight>
   </line>
   <line>
    <xstart>190</xstart>
    <ystart>110</ystart>
    <xend>280</xend>
    <yend>110</yend>
    <weight>0</weight>
   </line>
   <field>
    <rect>
     <x>228</x>
     <y>0</y>
     <width>85</width>
     <height>20</height>
    </rect>
    <font>
     <face>helvetica</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>qty_uom</column>
    </data>
   </field>
   <label>
    <rect>
     <x>565</x>
     <y>95</y>
     <width>60</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <top/>
    <string>Status:</string>
   </label>
   <line>
    <xstart>415</xstart>
    <ystart>110</ystart>
    <xend>500</xend>
    <yend>110</yend>
    <weight>0</weight>
   </line>
   <line>
    <xstart>305</xstart>
    <ystart>80</ystart>
    <xend>395</xend>
    <yend>80</yend>
    <weight>0</weight>
   </line>
   <field>
    <rect>
     <x>320</x>
     <y>0</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>helvetica</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>f_qtyord</column>
    </data>
   </field>
  </detail>
 </section>
 <pgfoot>
  <height>57</height>
  <field>
   <rect>
    <x>90</x>
    <y>5</y>
    <width>95</width>
    <height>17</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>Context Query</query>
    <column>report_date</column>
   </data>
  </field>
  <label>
   <rect>
    <x>695</x>
    <y>5</y>
    <width>37</width>
    <height>17</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <top/>
   <string>Page:</string>
  </label>
  <field>
   <rect>
    <x>455</x>
    <y>5</y>
    <width>80</width>
    <height>17</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>head</query>
    <column>cohead_number</column>
   </data>
  </field>
  <label>
   <rect>
    <x>360</x>
    <y>5</y>
    <width>90</width>
    <height>17</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <top/>
   <string>Sales Order #:</string>
  </label>
  <label>
   <rect>
    <x>25</x>
    <y>5</y>
    <width>62</width>
    <height>17</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <top/>
   <string>Print Date: </string>
  </label>
  <field>
   <rect>
    <x>735</x>
    <y>5</y>
    <width>45</width>
    <height>17</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>Context Query</query>
    <column>page_number</column>
   </data>
  </field>
 </pgfoot>
 <rptfoot>
  <height>113</height>
  <line>
   <xstart>185</xstart>
   <ystart>25</ystart>
   <xend>363</xend>
   <yend>25</yend>
   <weight>0</weight>
  </line>
  <line>
   <xstart>186</xstart>
   <ystart>90</ystart>
   <xend>360</xend>
   <yend>90</yend>
   <weight>0</weight>
  </line>
  <label>
   <rect>
    <x>40</x>
    <y>5</y>
    <width>165</width>
    <height>30</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Checked By:</string>
  </label>
  <label>
   <rect>
    <x>40</x>
    <y>65</y>
    <width>160</width>
    <height>35</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>14</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <string>Completed By:</string>
  </label>
 </rptfoot>
</report>
