<!DOCTYPE openRPTDef>
<report>
 <title>Sample Check Format</title>
 <name>CheckFormat</name>
 <description>OpenMFG Sample A/P Check Format</description>
 <size>Letter</size>
 <portrait/>
 <topmargin>50</topmargin>
 <bottommargin>50</bottommargin>
 <rightmargin>50</rightmargin>
 <leftmargin>50</leftmargin>
 <querysource>
  <name>Head</name>
  <sql>SELECT vend_name,
       vend_address1,
       vend_address3,
       vend_address3,
       vend_city,
       vend_state,
       vend_zip,
       formatDate(apchk_checkdate) AS f_checkdate,
       formatMoney(apchk_amount) AS f_amount,
       spellAmount(apchk_amount) AS f_words,
       CASE WHEN(apchk_void) THEN text('V O I D')
            ELSE text('')
       END AS f_void,
       apchk_for
  FROM apchk, vend
 WHERE ( (apchk_vend_id=vend_id)
   AND (apchk_id=&lt;? value(&quot;apchk_id&quot;) ?>) );</sql>
 </querysource>
 <querysource>
  <name>Detail</name>
  <sql>SELECT apchkitem_invcnumber, apchkitem_ponumber,
       formatMoney(apchkitem_amount) AS f_amount
FROM apchkitem
WHERE (apchkitem_apchk_id=%1)
ORDER BY apchkitem_invcnumber;</sql>
 </querysource>
 <pghead>
  <firstpage/>
  <height>197</height>
  <label>
   <rect>
    <x>525</x>
    <y>175</y>
    <width>83</width>
    <height>20</height>
   </rect>
   <font>
    <face>Helvetica [Urw]</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Amount</string>
  </label>
  <label>
   <rect>
    <x>530</x>
    <y>75</y>
    <width>20</width>
    <height>20</height>
   </rect>
   <font>
    <face>Helvetica [Urw]</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>$</string>
  </label>
  <label>
   <rect>
    <x>5</x>
    <y>155</y>
    <width>50</width>
    <height>20</height>
   </rect>
   <font>
    <face>Helvetica [Urw]</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Memo:</string>
  </label>
  <label>
   <rect>
    <x>270</x>
    <y>175</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Helvetica [Urw]</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Invoice #</string>
  </label>
  <field>
   <rect>
    <x>300</x>
    <y>75</y>
    <width>150</width>
    <height>40</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>f_void</column>
   </data>
  </field>
  <field>
   <rect>
    <x>60</x>
    <y>30</y>
    <width>150</width>
    <height>40</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>f_void</column>
   </data>
  </field>
  <label>
   <rect>
    <x>395</x>
    <y>175</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Helvetica [Urw]</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>P/O #</string>
  </label>
  <field>
   <rect>
    <x>60</x>
    <y>155</y>
    <width>325</width>
    <height>20</height>
   </rect>
   <font>
    <face>Helvetica</face>
    <size>12</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>Head</query>
    <column>apchk_for</column>
   </data>
  </field>
  <field>
   <rect>
    <x>555</x>
    <y>30</y>
    <width>150</width>
    <height>40</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>f_void</column>
   </data>
  </field>
  <field>
   <rect>
    <x>60</x>
    <y>120</y>
    <width>150</width>
    <height>40</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>f_void</column>
   </data>
  </field>
  <field>
   <rect>
    <x>85</x>
    <y>75</y>
    <width>185</width>
    <height>20</height>
   </rect>
   <font>
    <face>Helvetica</face>
    <size>12</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>Head</query>
    <column>vend_name</column>
   </data>
  </field>
  <field>
   <rect>
    <x>555</x>
    <y>20</y>
    <width>121</width>
    <height>20</height>
   </rect>
   <font>
    <face>Helvetica</face>
    <size>12</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>Head</query>
    <column>f_checkdate</column>
   </data>
  </field>
  <field>
   <rect>
    <x>45</x>
    <y>100</y>
    <width>675</width>
    <height>20</height>
   </rect>
   <font>
    <face>Helvetica</face>
    <size>12</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>Head</query>
    <column>f_words</column>
   </data>
  </field>
  <field>
   <rect>
    <x>555</x>
    <y>120</y>
    <width>150</width>
    <height>40</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <data>
    <query>Head</query>
    <column>f_void</column>
   </data>
  </field>
  <field>
   <rect>
    <x>555</x>
    <y>75</y>
    <width>150</width>
    <height>20</height>
   </rect>
   <font>
    <face>Helvetica</face>
    <size>12</size>
    <weight>normal</weight>
   </font>
   <left/>
   <top/>
   <data>
    <query>Head</query>
    <column>f_amount</column>
   </data>
  </field>
 </pghead>
 <section>
  <name>Apchkitem</name>
  <detail>
   <key>
    <query>Detail</query>
   </key>
   <height>22</height>
   <field>
    <rect>
     <x>509</x>
     <y>0</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Helvetica [Urw]</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>f_amount</column>
    </data>
   </field>
   <field>
    <rect>
     <x>390</x>
     <y>0</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Helvetica [Urw]</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>apchkitem_ponumber</column>
    </data>
   </field>
   <field>
    <rect>
     <x>270</x>
     <y>0</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Helvetica [Urw]</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>Detail</query>
     <column>apchkitem_invcnumber</column>
    </data>
   </field>
  </detail>
 </section>
</report>
