<!DOCTYPE openRPTDef>
<report>
 <title>Shipping Labels By Invoice</title>
 <name>ShippingLabelsByInvoice</name>
 <description></description>
 <labeltype>Avery 5263</labeltype>
 <size>Labels</size>
 <portrait/>
 <topmargin>100</topmargin>
 <bottommargin>100</bottommargin>
 <rightmargin>100</rightmargin>
 <leftmargin>100</leftmargin>
 <querysource>
  <name>detail</name>
  <sql>SELECT sequence_value,
       invchead_invcnumber,
       cust_number,
       invchead_ordernumber,
       invchead_ponumber,
       invchead_shipto_name,
       invchead_shipto_address1,
       invchead_shipto_address2,
       invchead_shipto_address3,
       (COALESCE(invchead_shipto_city,'') || ' ' || COALESCE(invchead_shipto_state,'') || ' ' || COALESCE(invchead_shipto_zipcode,'')) AS citystatezip
  FROM invchead, custinfo, sequence
 WHERE ( (invchead_cust_id=cust_id)
   AND (sequence_value BETWEEN &lt;? value(&quot;labelFrom&quot;) ?> AND &lt;? value(&quot;labelTo&quot;) ?>)
   AND (invchead_id=&lt;? value(&quot;invchead_id&quot;) ?>) );
       </sql>
 </querysource>
 <section>
  <name>detail</name>
  <detail>
   <key>
    <query>detail</query>
   </key>
   <height>201</height>
   <field>
    <rect>
     <x>100</x>
     <y>125</y>
     <width>155</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>cust_number</column>
    </data>
   </field>
   <label>
    <rect>
     <x>5</x>
     <y>140</y>
     <width>90</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Invoice #:</string>
   </label>
   <label>
    <rect>
     <x>15</x>
     <y>155</y>
     <width>80</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>P/O #:</string>
   </label>
   <label>
    <rect>
     <x>5</x>
     <y>125</y>
     <width>90</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Customer #:</string>
   </label>
   <field>
    <rect>
     <x>100</x>
     <y>140</y>
     <width>155</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>invchead_invcnumber</column>
    </data>
   </field>
   <field>
    <rect>
     <x>285</x>
     <y>180</y>
     <width>36</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>sequence_value</column>
    </data>
   </field>
   <field>
    <rect>
     <x>30</x>
     <y>85</y>
     <width>285</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>citystatezip</column>
    </data>
   </field>
   <field>
    <rect>
     <x>30</x>
     <y>40</y>
     <width>285</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>invchead_shipto_address1</column>
    </data>
   </field>
   <field>
    <rect>
     <x>340</x>
     <y>180</y>
     <width>36</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>Parameter Query</query>
     <column>labelTo</column>
    </data>
   </field>
   <label>
    <rect>
     <x>325</x>
     <y>180</y>
     <width>16</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <string> of </string>
   </label>
   <field>
    <rect>
     <x>30</x>
     <y>25</y>
     <width>285</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>invchead_shipto_name</column>
    </data>
   </field>
   <field>
    <rect>
     <x>30</x>
     <y>70</y>
     <width>285</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>invchead_shipto_address3</column>
    </data>
   </field>
   <field>
    <rect>
     <x>30</x>
     <y>55</y>
     <width>285</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>invchead_shipto_address2</column>
    </data>
   </field>
   <field>
    <rect>
     <x>100</x>
     <y>155</y>
     <width>155</width>
     <height>17</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>invchead_ponumber</column>
    </data>
   </field>
  </detail>
 </section>
</report>
