<?xml version="1.0" encoding="windows-1251"?>


    <jasperReport name="ReportName" >

    <queryString>
    <![CDATA[
        select register_num as num from ecm.doc_cards where doc_cards.id = 4
    ]]>
    <![CDATA[
        select card_gm_orders.sign_date as date from ecm.card_gm_orders, ecm.doc_cards
        where ecm.doc_cards.id = ecm.card_gm_orders.doc_cardid
        and ecm.card_gm_orders.doc_cardid = 4;
    ]]>
    <![CDATA[
        select ou.users.uname as uname_gen from
        ou.users, ecm.doc_bpm_roles
        where ou.users.id = ecm.doc_bpm_roles.userid
        and ecm.doc_bpm_roles.roleid = 31 group by ou.users.id
    ]]>
    <![CDATA[
        select ou.users.uname as uname_exec from
        ou.users, ecm.doc_bpm_roles
        where ou.users.id = ecm.doc_bpm_roles.userid
        and ecm.doc_bpm_roles.roleid = 27 group by ou.users.id
    ]]>
    <![CDATA[
        select ou.orgunit_users.post as uname_pos_mat_all from ecm.doc_bpm_roles,ou.orgunit_users
        where ecm.doc_bpm_roles.doc_cardid = 4
        and ecm.doc_bpm_roles.roleid = 24
        and ou.orgunit_users.userid = ecm.doc_bpm_roles.userid
    ]]>
    <![CDATA[
        select ou.users.uname as uname_pos_mat from
        ou.users, ecm.doc_bpm_roles
        where ou.users.id = ecm.doc_bpm_roles.userid
        and ecm.doc_bpm_roles.roleid = 24 group by ou.users.id
    ]]>
    <![CDATA[
        select ou.orgunit_users.post as uname_mach_all from ecm.doc_bpm_roles,ou.orgunit_users
        where ecm.doc_bpm_roles.doc_cardid = 4
        and ecm.doc_bpm_roles.roleid = 32
        and ou.orgunit_users.userid = ecm.doc_bpm_roles.userid
    ]]>
    <![CDATA[
        select ou.users.uname as uname_mach from
        ou.users, ecm.doc_bpm_roles
        where ou.users.id = ecm.doc_bpm_roles.userid
        and ecm.doc_bpm_roles.roleid = 32 group by ou.users.id
    ]]>
    </queryString>

        <field name="num" class="java.lang.String" />
        <field name="date" class="java.lang.String" />
        <field name="uname_gen" class="java.lang.String" />
        <field name="uname_exec" class="java.lang.String" />
        <field name="uname_pos_mat_all" class="java.lang.String" />
        <field name="uname_pos_mat" class="java.lang.String" />
        <field name="uname_mach_all" class="java.lang.String" />
        <field name="uname_mach" class="java.lang.String" />

<pageHeader>
     <band height="30">
         <staticText>
         <reportElement x="0" y="0" width="69" height="24" />
         <textElement verticalAlignment="Bottom" />
         <text>
         <![CDATA[Order Number: ]]>
         </text>
         </staticText>

         <staticText>
         <reportElement x="140" y="0" width="79" height="24" />
         <text>
         <![CDATA[Date: ]]>
         </text>
         </staticText>

         <staticText>
         <reportElement x="280" y="0" width="69" height="24" />
         <text>
         <![CDATA[Gen_dir: ]]>
         </text>
         </staticText>

         <staticText>
         <reportElement x="420" y="0" width="69" height="24" />
         <text>
         <![CDATA[Executor: ]]>
         </text>
         </staticText>

         <staticText>
         <reportElement x="420" y="0" width="69" height="24" />
         <text>
         <![CDATA[Position_matching: ]]>
         </text>
         </staticText>

         <staticText>
         <reportElement x="420" y="0" width="69" height="24" />
         <text>
         <![CDATA[Matching: ]]>
         </text>
         </staticText>

         <staticText>
         <reportElement x="420" y="0" width="69" height="24" />
         <text>
         <![CDATA[Acquaint: ]]>
         </text>
         </staticText>

         <staticText>
         <reportElement x="420" y="0" width="69" height="24" />
         <text>
         <![CDATA[person_for_familiarize: ]]>
         </text>
         </staticText>
     </band>
 </pageHeader>

 <detail>
     <band height="500">
         <textField evaluationTime="Report">
         <reportElement x="100" y="200" width="100" height="24" />
         <textFieldExpression class="java.lang.String">
         <![CDATA[$F{num}]]>
         </textFieldExpression>
         </textField>

         <textField evaluationTime="Report">
         <reportElement x="400" y="200" width="150" height="24" />
         <textFieldExpression class="java.lang.String">
         <![CDATA[$F{date}]]>
         </textFieldExpression>
         </textField>

         <textField evaluationTime="Report">
         <reportElement x="390" y="390" width="150" height="24" />
         <textFieldExpression class="java.lang.String">
         <![CDATA[$F{uname_gen}]]>
         </textFieldExpression>
         </textField>

         <textField evaluationTime="Report">
         <reportElement x="390" y="480" width="69" height="24" />
         <textFieldExpression class="java.lang.String">
         <![CDATA[$F{uname_exec}]]>
         </textFieldExpression>
         </textField>

         <textField evaluationTime="Report">
         <reportElement x="420" y="0" width="69" height="24" />
         <textFieldExpression class="java.lang.String">
         <![CDATA[$F{uname_pos_mat_all}]]>
         </textFieldExpression>
         </textField>

         <textField evaluationTime="Report">
         <reportElement x="420" y="0" width="69" height="24" />
         <textFieldExpression class="java.lang.String">
         <![CDATA[$F{uname_pos_mat}]]>
         </textFieldExpression>
         </textField>

         <textField evaluationTime="Report">
         <reportElement x="420" y="0" width="69" height="24" />
         <textFieldExpression class="java.lang.String">
         <![CDATA[$F{uname_mach_all}]]>
         </textFieldExpression>
         </textField>

         <textField evaluationTime="Report">
         <reportElement x="420" y="0" width="69" height="24" />
         <textFieldExpression class="java.lang.String">
         <![CDATA[$F{uname_mach}]]>
         </textFieldExpression>
         </textField>
     </band>
 </detail>

</jasperReport>