<!DOCTYPE openRPTDef>
<report>
 <title>WO Order Label</title>
 <name>WOLabel</name>
 <description>Labels generated for use in labeling parts out of a work order</description>
 <grid>
  <snap/>
  <show/>
  <x>0.05</x>
  <y>0.05</y>
 </grid>
 <size>
  <width>400</width>
  <height>333</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,
 COALESCE(prodcat_descrip, '') AS prodcat_descrip 
 FROM wo JOIN itemsite ON (itemsite_id=wo_itemsite_id)
         JOIN item ON (item_id=itemsite_item_id)
         JOIN sequence ON (sequence.sequence_value BETWEEN 1 AND &lt;? value("labelTo") ?>)
         LEFT OUTER JOIN prodcat ON (prodcat_id=item_prodcat_id)
WHERE (wo_id=&lt;? value("wo_id") ?>);
</sql>
 </querysource>
 <section>
  <name>detail</name>
  <detail>
   <key>
    <query>detail</query>
   </key>
   <height>218</height>
   <field>
    <rect>
     <x>10</x>
     <y>150</y>
     <width>330</width>
     <height>25</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>12</size>
     <weight>bold</weight>
    </font>
    <left/>
    <top/>
    <data>
     <query>detail</query>
     <column>item_descrip1</column>
    </data>
   </field>
   <field>
    <rect>
     <x>10</x>
     <y>95</y>
     <width>330</width>
     <height>25</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>12</size>
     <weight>bold</weight>
    </font>
    <left/>
    <top/>
    <data>
     <query>detail</query>
     <column>prodcat_descrip</column>
    </data>
   </field>
   <barcode>
    <rect>
     <x>10</x>
     <y>180</y>
     <width>330</width>
     <height>25</height>
    </rect>
    <format>3of9</format>
    <maxlength>5</maxlength>
    <left/>
    <narrowBarWidth>0.01</narrowBarWidth>
    <data>
     <query>detail</query>
     <column>item_number</column>
    </data>
   </barcode>
   <field>
    <rect>
     <x>150</x>
     <y>35</y>
     <width>120</width>
     <height>18</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>12</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <top/>
    <data>
     <query>detail</query>
     <column>due_date</column>
    </data>
   </field>
   <field>
    <rect>
     <x>75</x>
     <y>125</y>
     <width>265</width>
     <height>18</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>12</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>item_number</column>
    </data>
   </field>
   <label>
    <rect>
     <x>10</x>
     <y>125</y>
     <width>61</width>
     <height>18</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>12</size>
     <weight>bold</weight>
    </font>
    <left/>
    <top/>
    <string>PART #:</string>
   </label>
  </detail>
 </section>
</report>
