<!DOCTYPE openRPTDef>
<report>
 <title>Item Master</title>
 <name>ItemMaster</name>
 <description></description>
 <size>Letter</size>
 <portrait/>
 <topmargin>50</topmargin>
 <bottommargin>50</bottommargin>
 <rightmargin>50</rightmargin>
 <leftmargin>50</leftmargin>
 <querysource>
  <name>head</name>
  <sql>SELECT item_number,
       formatBoolYN(item_active) AS f_item_active,
       item_descrip1, item_descrip2,
       CASE WHEN(item_type='P') THEN 'Purchased'
            WHEN(item_type='M') THEN 'Manufactured'
            WHEN(item_type='J') THEN 'Job'
            WHEN(item_type='F') THEN 'Phantom'
            WHEN(item_type='B') THEN 'Breeder'
            WHEN(item_type='C') THEN 'Co-Product'
            WHEN(item_type='Y') THEN 'By-Product'
            WHEN(item_type='R') THEN 'Reference'
            WHEN(item_type='T') THEN 'Tooling'
            WHEN(item_type='O') THEN 'Outside Process'
            WHEN(item_type='K') THEN 'Kit'
            ELSE item_type
       END AS f_item_type,
       formatBoolYN(item_config) AS f_item_config,
       (classcode_code||' - '||classcode_descrip) AS f_classcode,
       CASE WHEN (COALESCE(freightclass_id, -1) &lt;> -1) THEN (freightclass_code||' - '||freightclass_descrip) END AS f_freightclass,
       iuom.uom_name AS invuom,
       formatBoolYN(item_picklist) AS f_item_picklist,
       formatBoolYN(item_fractional) AS f_item_fractional,
       itemcapuom(item_id) AS capuom, itemaltcapuom(item_id) AS altcapuom, puom.uom_name AS shipuom,
       formatUOMRatio(itemcapinvrat(item_id)) AS f_capinvrat,
       formatUOMRatio(itemaltcapinvrat(item_id)) AS f_altcapinvrat,
       formatUOMRatio(iteminvpricerat(item_id)) AS f_shipinvrat,
       formatWeight(item_prodweight) AS f_item_prodweight,
       formatWeight(item_packweight) AS f_item_packweight,
       formatBoolYN(item_sold) AS f_item_sold
  FROM item JOIN classcode ON (classcode_id=item_classcode_id)
            JOIN uom iuom ON (iuom.uom_id=item_inv_uom_id)
            JOIN uom puom ON (puom.uom_id=item_price_uom_id)
            LEFT OUTER JOIN freightclass ON (freightclass_id=item_freightclass_id)
 WHERE (item_id=&lt;? value("item_id") ?>)
;</sql>
 </querysource>
 <querysource>
  <name>sold</name>
  <sql>SELECT uom_name,
       formatUOMRatio(iteminvpricerat(item_id)) AS f_iteminvpricerat,
       (prodcat_code||' - '||prodcat_descrip) AS f_prodcat,
       formatBoolYN(item_exclusive) AS f_item_exclusive,
       formatPrice(item_listprice) AS f_item_listprice,
       formatExtPrice(item_listprice / iteminvpricerat(item_id)) AS f_extprice
  FROM item, prodcat, uom
 WHERE ((item_id=&lt;? value("item_id") ?>)
   AND  (item_price_uom_id=uom_id)
   AND  (item_sold)
   AND  (item_prodcat_id=prodcat_id) );</sql>
 </querysource>
 <querysource>
  <name>notes</name>
  <sql>SELECT item_comments, item_extdescrip
  FROM item
 WHERE (item_id=&lt;? value("item_id") ?>);</sql>
 </querysource>
 <querysource>
  <name>itemchar</name>
  <sql>SELECT 1 as one,
       char_name as charass_name,
       charass_value
  FROM charass, char
 WHERE ((charass_target_type='I')
   AND (charass_char_id=char_id)
   AND (charass_target_id=&lt;? value("item_id") ?>))
ORDER BY char_name;</sql>
 </querysource>
 <querysource>
  <name>imglist</name>
  <sql>SELECT 1 as one,
       image_name, firstLine(image_descrip) as f_descrip,
       CASE WHEN (imageass_purpose='I') THEN 'Inventory Description'
            WHEN (imageass_purpose='P') THEN 'Product Description'
            WHEN (imageass_purpose='E') THEN 'Engineering Reference'
            WHEN (imageass_purpose='M') THEN 'Miscellaneous'
            ELSE 'Other'
       END as f_purpose
FROM imageass, image
WHERE ( (imageass_image_id=image_id)
 AND (imageass_source='I')
 AND (imageass_source_id=&lt;? value("item_id") ?>) )
ORDER BY image_name;</sql>
 </querysource>
 <querysource>
  <name>comments</name>
  <sql>SELECT 1 as one,
       formatDate(comment_date) as f_date,
       comment_user,
       comment_text
FROM comment
WHERE ( (comment_source='I')
 AND (comment_source_id=&lt;? value("item_id") ?>) )
ORDER BY comment_date;</sql>
 </querysource>
 <rpthead>
  <height>333</height>
  <field>
   <rect>
    <x>135</x>
    <y>310</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_item_sold</column>
   </data>
  </field>
  <label>
   <rect>
    <x>260</x>
    <y>252</y>
    <width>200</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Shipping/Inventory UOM Ratio:</string>
  </label>
  <field>
   <rect>
    <x>465</x>
    <y>252</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_shipinvrat</column>
   </data>
  </field>
  <label>
   <rect>
    <x>30</x>
    <y>285</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Product Weight:</string>
  </label>
  <label>
   <rect>
    <x>260</x>
    <y>285</y>
    <width>125</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Packaging Weight:</string>
  </label>
  <label>
   <rect>
    <x>400</x>
    <y>135</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Configured:</string>
  </label>
  <field>
   <rect>
    <x>505</x>
    <y>135</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_item_config</column>
   </data>
  </field>
  <field>
   <rect>
    <x>505</x>
    <y>155</y>
    <width>225</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_freightclass</column>
   </data>
  </field>
  <label>
   <rect>
    <x>5</x>
    <y>227</y>
    <width>125</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Alt. Capacity UOM:</string>
  </label>
  <field>
   <rect>
    <x>135</x>
    <y>227</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>altcapuom</column>
   </data>
  </field>
  <field>
   <rect>
    <x>390</x>
    <y>285</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_item_packweight</column>
   </data>
  </field>
  <field>
   <rect>
    <x>465</x>
    <y>207</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_capinvrat</column>
   </data>
  </field>
  <field>
   <rect>
    <x>135</x>
    <y>102</y>
    <width>400</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>item_descrip2</column>
   </data>
  </field>
  <label>
   <rect>
    <x>335</x>
    <y>5</y>
    <width>400</width>
    <height>40</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>18</size>
    <weight>bold</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Item Master</string>
  </label>
  <label>
   <rect>
    <x>482</x>
    <y>185</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Fractional:</string>
  </label>
  <label>
   <rect>
    <x>30</x>
    <y>252</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Shipping UOM:</string>
  </label>
  <field>
   <rect>
    <x>135</x>
    <y>155</y>
    <width>200</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_classcode</column>
   </data>
  </field>
  <field>
   <rect>
    <x>135</x>
    <y>135</y>
    <width>200</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_item_type</column>
   </data>
  </field>
  <field>
   <rect>
    <x>135</x>
    <y>65</y>
    <width>300</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>item_number</column>
   </data>
  </field>
  <field>
   <rect>
    <x>135</x>
    <y>185</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>invuom</column>
   </data>
  </field>
  <label>
   <rect>
    <x>30</x>
    <y>310</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Item is Sold:</string>
  </label>
  <label>
   <rect>
    <x>265</x>
    <y>185</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Pick List Item:</string>
  </label>
  <label>
   <rect>
    <x>260</x>
    <y>207</y>
    <width>200</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Capacity/Inventory UOM Ratio:</string>
  </label>
  <field>
   <rect>
    <x>465</x>
    <y>227</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_altcapinvrat</column>
   </data>
  </field>
  <label>
   <rect>
    <x>457</x>
    <y>65</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Active:</string>
  </label>
  <label>
   <rect>
    <x>30</x>
    <y>185</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Inventory UOM:</string>
  </label>
  <label>
   <rect>
    <x>30</x>
    <y>155</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Class Code:</string>
  </label>
  <field>
   <rect>
    <x>135</x>
    <y>252</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>shipuom</column>
   </data>
  </field>
  <field>
   <rect>
    <x>135</x>
    <y>285</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_item_prodweight</column>
   </data>
  </field>
  <field>
   <rect>
    <x>135</x>
    <y>207</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>capuom</column>
   </data>
  </field>
  <field>
   <rect>
    <x>135</x>
    <y>85</y>
    <width>400</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>item_descrip1</column>
   </data>
  </field>
  <field>
   <rect>
    <x>565</x>
    <y>65</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_item_active</column>
   </data>
  </field>
  <label>
   <rect>
    <x>240</x>
    <y>227</y>
    <width>220</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Alt. Capacity/Inventory UOM Ratio:</string>
  </label>
  <label>
   <rect>
    <x>400</x>
    <y>155</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Freight Class:</string>
  </label>
  <label>
   <rect>
    <x>30</x>
    <y>65</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Item #:</string>
  </label>
  <label>
   <rect>
    <x>10</x>
    <y>135</y>
    <width>120</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Item Type:</string>
  </label>
  <label>
   <rect>
    <x>30</x>
    <y>207</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Capacity UOM:</string>
  </label>
  <field>
   <rect>
    <x>590</x>
    <y>185</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_item_fractional</column>
   </data>
  </field>
  <field>
   <rect>
    <x>370</x>
    <y>185</y>
    <width>100</width>
    <height>20</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>10</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>head</query>
    <column>f_item_picklist</column>
   </data>
  </field>
 </rpthead>
 <section>
  <name>sold</name>
  <detail>
   <key>
    <query>sold</query>
   </key>
   <height>93</height>
   <label>
    <rect>
     <x>65</x>
     <y>65</y>
     <width>140</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Ext. Price:</string>
   </label>
   <field>
    <rect>
     <x>207</x>
     <y>45</y>
     <width>200</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>sold</query>
     <column>f_item_listprice</column>
    </data>
   </field>
   <field>
    <rect>
     <x>640</x>
     <y>45</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>sold</query>
     <column>f_item_exclusive</column>
    </data>
   </field>
   <label>
    <rect>
     <x>65</x>
     <y>25</y>
     <width>140</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Product Category:</string>
   </label>
   <label>
    <rect>
     <x>65</x>
     <y>45</y>
     <width>140</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>List Price:</string>
   </label>
   <label>
    <rect>
     <x>535</x>
     <y>45</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Exclusive</string>
   </label>
   <field>
    <rect>
     <x>207</x>
     <y>25</y>
     <width>300</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>sold</query>
     <column>f_prodcat</column>
    </data>
   </field>
   <field>
    <rect>
     <x>545</x>
     <y>5</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>sold</query>
     <column>f_iteminvpricerat</column>
    </data>
   </field>
   <label>
    <rect>
     <x>340</x>
     <y>5</y>
     <width>200</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Price/Inventory UOM Ratio:</string>
   </label>
   <field>
    <rect>
     <x>207</x>
     <y>65</y>
     <width>200</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>sold</query>
     <column>f_extprice</column>
    </data>
   </field>
   <label>
    <rect>
     <x>535</x>
     <y>25</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Taxable:</string>
   </label>
   <field>
    <rect>
     <x>207</x>
     <y>5</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>sold</query>
     <column>uom_name</column>
    </data>
   </field>
   <label>
    <rect>
     <x>102</x>
     <y>5</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Price UOM:</string>
   </label>
  </detail>
 </section>
 <section>
  <name>notes</name>
  <detail>
   <key>
    <query>notes</query>
   </key>
   <height>36</height>
   <label>
    <rect>
     <x>15</x>
     <y>5</y>
     <width>100</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Notes:</string>
   </label>
   <text>
    <rect>
     <x>120</x>
     <y>5</y>
     <width>615</width>
     <height>20</height>
    </rect>
    <bottompad>5</bottompad>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>notes</query>
     <column>item_comments</column>
    </data>
   </text>
  </detail>
 </section>
 <section>
  <name>extdescrip</name>
  <detail>
   <key>
    <query>notes</query>
   </key>
   <height>36</height>
   <label>
    <rect>
     <x>5</x>
     <y>5</y>
     <width>110</width>
     <height>20</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>normal</weight>
    </font>
    <right/>
    <vcenter/>
    <string>Ext. Description:</string>
   </label>
   <text>
    <rect>
     <x>120</x>
     <y>5</y>
     <width>615</width>
     <height>20</height>
    </rect>
    <bottompad>5</bottompad>
    <font>
     <face>Arial</face>
     <size>10</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>notes</query>
     <column>item_extdescrip</column>
    </data>
   </text>
  </detail>
 </section>
 <section>
  <name>itemchar</name>
  <group>
   <name>itemchar</name>
   <column>one</column>
   <head>
    <height>57</height>
    <line>
     <xstart>120</xstart>
     <ystart>50</ystart>
     <xend>690</xend>
     <yend>50</yend>
     <weight>0</weight>
    </line>
    <label>
     <rect>
      <x>300</x>
      <y>35</y>
      <width>100</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Value</string>
    </label>
    <label>
     <rect>
      <x>50</x>
      <y>10</y>
      <width>145</width>
      <height>20</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Item Characteristics</string>
    </label>
    <label>
     <rect>
      <x>125</x>
      <y>35</y>
      <width>100</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Characteristic</string>
    </label>
   </head>
  </group>
  <detail>
   <key>
    <query>itemchar</query>
   </key>
   <height>21</height>
   <field>
    <rect>
     <x>300</x>
     <y>0</y>
     <width>385</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>itemchar</query>
     <column>charass_value</column>
    </data>
   </field>
   <field>
    <rect>
     <x>125</x>
     <y>0</y>
     <width>160</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>itemchar</query>
     <column>charass_name</column>
    </data>
   </field>
  </detail>
 </section>
 <section>
  <name>imglist</name>
  <group>
   <name>imglist</name>
   <column>one</column>
   <head>
    <height>57</height>
    <label>
     <rect>
      <x>575</x>
      <y>35</y>
      <width>110</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <hcenter/>
     <vcenter/>
     <string>Purpose</string>
    </label>
    <label>
     <rect>
      <x>125</x>
      <y>35</y>
      <width>100</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Name</string>
    </label>
    <label>
     <rect>
      <x>50</x>
      <y>10</y>
      <width>145</width>
      <height>20</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Image List:</string>
    </label>
    <label>
     <rect>
      <x>250</x>
      <y>35</y>
      <width>100</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Description</string>
    </label>
    <line>
     <xstart>120</xstart>
     <ystart>50</ystart>
     <xend>690</xend>
     <yend>50</yend>
     <weight>0</weight>
    </line>
   </head>
  </group>
  <detail>
   <key>
    <query>imglist</query>
   </key>
   <height>21</height>
   <field>
    <rect>
     <x>565</x>
     <y>0</y>
     <width>130</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>imglist</query>
     <column>f_purpose</column>
    </data>
   </field>
   <field>
    <rect>
     <x>125</x>
     <y>0</y>
     <width>120</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>imglist</query>
     <column>image_name</column>
    </data>
   </field>
   <field>
    <rect>
     <x>250</x>
     <y>0</y>
     <width>315</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>imglist</query>
     <column>f_descrip</column>
    </data>
   </field>
  </detail>
 </section>
 <section>
  <name>comments</name>
  <group>
   <name>comments</name>
   <column>one</column>
   <head>
    <height>57</height>
    <label>
     <rect>
      <x>207</x>
      <y>35</y>
      <width>100</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>User</string>
    </label>
    <label>
     <rect>
      <x>315</x>
      <y>35</y>
      <width>110</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Comment</string>
    </label>
    <label>
     <rect>
      <x>50</x>
      <y>10</y>
      <width>145</width>
      <height>20</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>10</size>
      <weight>normal</weight>
     </font>
     <left/>
     <vcenter/>
     <string>Comments:</string>
    </label>
    <line>
     <xstart>120</xstart>
     <ystart>50</ystart>
     <xend>690</xend>
     <yend>50</yend>
     <weight>0</weight>
    </line>
    <label>
     <rect>
      <x>125</x>
      <y>35</y>
      <width>80</width>
      <height>15</height>
     </rect>
     <font>
      <face>Arial</face>
      <size>8</size>
      <weight>normal</weight>
     </font>
     <hcenter/>
     <vcenter/>
     <string>Date</string>
    </label>
   </head>
  </group>
  <detail>
   <key>
    <query>comments</query>
   </key>
   <height>21</height>
   <text>
    <rect>
     <x>315</x>
     <y>0</y>
     <width>370</width>
     <height>15</height>
    </rect>
    <bottompad>5</bottompad>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>comments</query>
     <column>comment_text</column>
    </data>
   </text>
   <field>
    <rect>
     <x>207</x>
     <y>0</y>
     <width>100</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <left/>
    <vcenter/>
    <data>
     <query>comments</query>
     <column>comment_user</column>
    </data>
   </field>
   <field>
    <rect>
     <x>125</x>
     <y>0</y>
     <width>80</width>
     <height>15</height>
    </rect>
    <font>
     <face>Arial</face>
     <size>8</size>
     <weight>bold</weight>
    </font>
    <hcenter/>
    <vcenter/>
    <data>
     <query>comments</query>
     <column>f_date</column>
    </data>
   </field>
  </detail>
 </section>
 <pgfoot>
  <height>21</height>
  <label>
   <rect>
    <x>0</x>
    <y>0</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Report Date:</string>
  </label>
  <label>
   <rect>
    <x>600</x>
    <y>0</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>normal</weight>
   </font>
   <right/>
   <vcenter/>
   <string>Page:</string>
  </label>
  <field>
   <rect>
    <x>102</x>
    <y>0</y>
    <width>100</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Context Query</query>
    <column>report_date</column>
   </data>
  </field>
  <field>
   <rect>
    <x>705</x>
    <y>0</y>
    <width>40</width>
    <height>15</height>
   </rect>
   <font>
    <face>Arial</face>
    <size>8</size>
    <weight>bold</weight>
   </font>
   <left/>
   <vcenter/>
   <data>
    <query>Context Query</query>
    <column>page_number</column>
   </data>
  </field>
 </pgfoot>
</report>
