<!DOCTYPE openRPTDef>
<report>
 <title>Location Dispatch List</title>
 <name>LocationDispatchList</name>
 <description></description>
 <size>Letter</size>
 <landscape/>
 <topmargin>50</topmargin>
 <bottommargin>50</bottommargin>
 <rightmargin>50</rightmargin>
 <leftmargin>50</leftmargin>
 <querysource>
  <name>head</name>
  <sql>SELECT warehous_code
FROM whsinfo
WHERE (warehous_id=%1);</sql>
 </querysource>
 <querysource>
  <name>detail</name>
  <sql>SELECT formatLocationBarcode(location_id) AS barcode,
       formatLocationIssueBarcode(location_id) AS issuebarcode,
       formatLocationContentsBarcode(location_id) AS contentsbarcode,
       location_name, firstLine(location_descrip) AS description
FROM location
WHERE (location_id IN (%2))
ORDER BY location_name;</sql>
 </querysource>
 <rpthead>
  <height>131</height>
  <label>
   <rect>
    <x>335</x>
    <y>100</y>
    <width>280</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>View Contents</string>
  </label>
  <line>
   <xstart>5</xstart>
   <ystart>125</ystart>
   <xend>985</xend>
   <yend>125</yend>
   <weight>2</weight>
  </line>
  <label>
   <rect>
    <x>395</x>
    <y>35</y>
    <width>110</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>12</size>
    <weight>bold</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Site:</string>
  </label>
  <label>
   <rect>
    <x>350</x>
    <y>5</y>
    <width>284</width>
    <height>31</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>16</size>
    <weight>bold</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Location Dispatch List</string>
  </label>
  <field>
   <rect>
    <x>510</x>
    <y>35</y>
    <width>80</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>12</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>warehous_code</column>
   </data>
  </field>
  <label>
   <rect>
    <x>670</x>
    <y>95</y>
    <width>280</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Issue Balance and Post</string>
  </label>
  <label>
   <rect>
    <x>5</x>
    <y>100</y>
    <width>280</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>General Use</string>
  </label>
  <label>
   <rect>
    <x>170</x>
    <y>80</y>
    <width>125</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Description</string>
  </label>
  <label>
   <rect>
    <x>15</x>
    <y>80</y>
    <width>125</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <hcenter/>
   <vcenter/>
   <string>Location</string>
  </label>
 </rpthead>
 <section>
  <name>detail</name>
  <group>
   <name>detail</name>
   <column>location_name</column>
  </group>
  <detail>
   <key>
    <query>detail</query>
   </key>
   <height>71</height>
   <field>
    <rect>
     <x>15</x>
     <y>5</y>
     <width>125</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>location_name</column>
    </data>
   </field>
   <barcode>
    <rect>
     <x>335</x>
     <y>30</y>
     <width>280</width>
     <height>25</height>
    </rect>
    <format>128</format>
    <maxlength>20</maxlength>
    <left/>
    <data>
     <query>detail</query>
     <column>contentsbarcode</column>
    </data>
   </barcode>
   <barcode>
    <rect>
     <x>5</x>
     <y>30</y>
     <width>280</width>
     <height>25</height>
    </rect>
    <format>128</format>
    <maxlength>20</maxlength>
    <left/>
    <data>
     <query>detail</query>
     <column>barcode</column>
    </data>
   </barcode>
   <barcode>
    <rect>
     <x>670</x>
     <y>30</y>
     <width>280</width>
     <height>25</height>
    </rect>
    <format>128</format>
    <maxlength>20</maxlength>
    <left/>
    <data>
     <query>detail</query>
     <column>issuebarcode</column>
    </data>
   </barcode>
   <field>
    <rect>
     <x>170</x>
     <y>5</y>
     <width>275</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>detail</query>
     <column>description</column>
    </data>
   </field>
   <line>
    <xstart>5</xstart>
    <ystart>65</ystart>
    <xend>985</xend>
    <yend>65</yend>
    <weight>0</weight>
   </line>
  </detail>
 </section>
</report>
