<!DOCTYPE openRPTDef>
<report>
 <title>WO Order Label</title>
 <name>WOLabelForm</name>
 <description>Labels generated for use in labeling parts out of a work order</description>
 <size>
  <width>275</width>
  <height>212</height>
 </size>
 <portrait/>
 <topmargin>25</topmargin>
 <bottommargin>25</bottommargin>
 <rightmargin>25</rightmargin>
 <leftmargin>25</leftmargin>
 <querysource>
  <name>detail</name>
  <sql>SELECT 
 sequence_value,
 formatDate(wo_duedate) AS due_date, 
 item_number,
 item_descrip1,
 prodcat_descrip 
 FROM 
 wo, 
 itemsite,
 item,
 prodcat,
 sequence
WHERE ( (wo_itemsite_id = itemsite_id)
AND (wo_id=&lt;? value(&quot;wo_id&quot;) ?>)
AND (item_prodcat_id = prodcat_id)
AND (itemsite_item_id = item_id)
AND (sequence.sequence_value 
BETWEEN 1 AND 1));</sql>
 </querysource>
 <section>
  <name>detail</name>
  <detail>
   <key>
    <query>detail</query>
   </key>
   <height>214</height>
   <field>
    <rect>
     <x>21</x>
     <y>91</y>
     <width>192</width>
     <height>25</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>prodcat_descrip</column>
    </data>
   </field>
   <barcode>
    <rect>
     <x>10</x>
     <y>182</y>
     <width>212</width>
     <height>25</height>
    </rect>
    <format>3of9</format>
    <maxlength>5</maxlength>
    <center/>
    <data>
     <query>detail</query>
     <column>item_number</column>
    </data>
   </barcode>
   <label>
    <rect>
     <x>10</x>
     <y>125</y>
     <width>52</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <top/>
    <string>PART #:</string>
   </label>
   <field>
    <rect>
     <x>62</x>
     <y>122</y>
     <width>265</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_number</column>
    </data>
   </field>
   <field>
    <rect>
     <x>145</x>
     <y>5</y>
     <width>77</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>9</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <top/>
    <data>
     <query>detail</query>
     <column>due_date</column>
    </data>
   </field>
   <field>
    <rect>
     <x>20</x>
     <y>151</y>
     <width>185</width>
     <height>25</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_descrip1</column>
    </data>
   </field>
  </detail>
 </section>
</report>
