1、添加报表
2、修改添加报表报错

 src/main/resources/mapper/ReportMapper.xml

@@ -4,7 +4,7 @@

    <!-- 获取最大排序号 -->
    <select id="selectMaxSortNum" parameterType="Long" resultType="int">
        select ifnull(max(sort_num), 0) sortNum
        select NVL(max(sort_num), 0) sortNum
        FROM cnf_report
        where module_id = #{moduleId}
    </select>

 src/main/webapp/WEB-INF/ureportfiles/borrow_approval_gh.ureport.xml

New file
@@ -0,0 +1,13 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" col-span="13"><cell-style font-size="14" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"></cell-style><simple-value><![CDATA[样品服务申请表]]></simple-value></cell><cell expand="None" name="A2" row="2" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人
]]></simple-value></cell><cell expand="None" name="D2" row="2" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="APPLY_USER" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G2" row="2" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[联系方式]]></simple-value></cell><cell expand="None" name="I2" row="2" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="TEL_NUMBER" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A3" row="3" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[所在部门]]></simple-value></cell><cell expand="None" name="D3" row="3" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="DEPT_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G3" row="3" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[预约时段
]]></simple-value></cell><cell expand="None" name="I3" row="3" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="OBSERVATION_TIME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A4" row="4" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[利用方式：]]></simple-value></cell><cell expand="None" name="D4" row="4" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A5" row="5" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[样品所属项目：]]></simple-value></cell><cell expand="None" name="D5" row="5" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="PROJECT_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A6" row="6" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请用途及成效]]></simple-value></cell><cell expand="None" name="D6" row="6" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="RESEARCH_PURPOSE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A7" row="7" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[样品类型]]></simple-value></cell><cell expand="None" name="D7" row="7" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[所属海域
或航次
]]></simple-value></cell><cell expand="None" name="G7" row="7" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[站位]]></simple-value></cell><cell expand="None" name="H7" row="7" col="8" col-span="6"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[取样或资料复制要求]]></simple-value></cell><cell expand="Down" name="A8" row="8" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="SAMPLE_TYPE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="D8" row="8" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="VESSEL_VOYAGE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="G8" row="8" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="POSITION" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="H8" row="8" col="8" col-span="6"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A9" row="9" col="1" row-span="3" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[项目负责人意见]]></simple-value></cell><cell expand="None" name="D9" row="9" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="G9" row="9" col="7" row-span="3" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请部门意见]]></simple-value></cell><cell expand="None" name="I9" row="9" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="D10" row="10" col="4"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[负责人：]]></simple-value></cell><cell expand="None" name="E10" row="10" col="5" col-span="2"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="I10" row="10" col="9" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[负责人：]]></simple-value></cell><cell expand="None" name="K10" row="10" col="11" col-span="3"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="D11" row="11" col="4"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="E11" row="11" col="5" col-span="2"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[年  月  日]]></simple-value></cell><cell expand="None" name="I11" row="11" col="9" col-span="2"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="K11" row="11" col="11" col-span="3"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[年  月  日]]></simple-value></cell><cell expand="None" name="A12" row="12" col="1" row-span="5" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[归口管理
部门意见
（保护期内样品）
]]></simple-value></cell><cell expand="None" name="D12" row="12" col="4" row-span="3" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="D15" row="15" col="4"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="E15" row="15" col="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="F15" row="15" col="6"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="G15" row="15" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="H15" row="15" col="8" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[负责人：]]></simple-value></cell><cell expand="None" name="K15" row="15" col="11" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="D16" row="16" col="4"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="E16" row="16" col="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="F16" row="16" col="6"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="G16" row="16" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="H16" row="16" col="8"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="I16" row="16" col="9"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="J16" row="16" col="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="K16" row="16" col="11" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[年  月  日]]></simple-value></cell><cell expand="None" name="A17" row="17" col="1" row-span="3" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[海洋实物资料所
意见]]></simple-value></cell><cell expand="None" name="D17" row="17" col="4" col-span="10"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="D18" row="18" col="4" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="F18" row="18" col="6" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="H18" row="18" col="8" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[负责人：]]></simple-value></cell><cell expand="None" name="K18" row="18" col="11" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="D19" row="19" col="4" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="F19" row="19" col="6" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="H19" row="19" col="8"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="I19" row="19" col="9"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="J19" row="19" col="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="K19" row="19" col="11" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[年  月  日]]></simple-value></cell><row row-number="1" height="26" band="title"/><row row-number="2" height="27" band="title"/><row row-number="3" height="26" band="title"/><row row-number="4" height="26" band="title"/><row row-number="5" height="25" band="title"/><row row-number="6" height="23" band="title"/><row row-number="7" height="26"/><row row-number="8" height="25"/><row row-number="9" height="39" band="summary"/><row row-number="10" height="17" band="summary"/><row row-number="11" height="17" band="summary"/><row row-number="12" height="20" band="summary"/><row row-number="13" height="19" band="summary"/><row row-number="14" height="15" band="summary"/><row row-number="15" height="15" band="summary"/><row row-number="16" height="16" band="summary"/><row row-number="17" height="41" band="summary"/><row row-number="18" height="19" band="summary"/><row row-number="19" height="19" band="summary"/><column col-number="1" width="34"/><column col-number="2" width="47"/><column col-number="3" width="20"/><column col-number="4" width="67"/><column col-number="5" width="40"/><column col-number="6" width="64"/><column col-number="7" width="50"/><column col-number="8" width="26"/><column col-number="9" width="44"/><column col-number="10" width="43"/><column col-number="11" width="45"/><column col-number="12" width="25"/><column col-number="13" width="34"/><footer  font-family="宋体" font-size="10" forecolor="0,0,0" margin="23"><center><![CDATA["第"+page()+"页,共"+pages()+"页"]]></center></footer><datasource name="内置数据源" type="buildin"><dataset name="table2" type="sql"><sql><![CDATA[SELECT
    * 
    FROM UTL_PHYSICAL_DETAIL WHERE FORM_ID = (:formId)]]></sql><field name="DETAIL_ID"/><field name="FORM_ID"/><field name="KEY_ID"/><field name="ARCHIVAL_CODE"/><field name="ITEM_NUMBER"/><field name="FILE_ID"/><field name="ITEM_ID"/><field name="FILE_TITLE"/><field name="ITEM_TITLE"/><field name="PROCESSING_TYPE"/><field name="SURVEY"/><field name="SAMPLING"/><field name="AGREE"/><field name="DRILLING_NAME"/><field name="SAMPLING_DEPTH"/><field name="CREATE_USER_ID"/><field name="CREATE_USER_NAME"/><field name="CREATE_TIME"/><field name="MODIFY_TIME"/><field name="CREATE_DEPT_ID"/><field name="CREATE_DEPT_NAME"/><field name="PROJECT_NAME"/><field name="PROJECT_NUM"/><field name="POSITION"/><field name="SAMPLE_NUM"/><field name="SAMPLE_TYPE"/><field name="VESSEL_VOYAGE"/><field name="SURVEYED_AREA"/><parameter name="formId" type="String" default-value="-1"/></dataset><dataset name="table3" type="sql"><sql><![CDATA[select * from UTL_PHYSICAL_FORM where FORM_ID =(:formId)]]></sql><field name="FORM_ID"/><field name="APPLY_CODE"/><field name="UTILIZATION_TYPE"/><field name="DEPT_NAME"/><field name="DEPT_ADDRESS"/><field name="APPLY_USER"/><field name="CARD_ID"/><field name="TEL_NUMBER"/><field name="EMAIL"/><field name="PROJECT_NAME"/><field name="TITLE"/><field name="ARCHIVAL_CODE"/><field name="OBSERVATION_SCOPE"/><field name="OBSERVATION_TIME"/><field name="SAMPLE_NUM"/><field name="SAMPLE_METHOD"/><field name="TEST_PROJECT"/><field name="SEND_INSTITUTION"/><field name="RESEARCH_PURPOSE"/><field name="RESEARCH_CONTENT"/><field name="EXPECTED_RESULT"/><field name="APPLY_DEPT_OPINION"/><field name="AGREE"/><field name="PHYSICAL_DATE"/><field name="REMARK"/><field name="CREATE_USER_ID"/><field name="CREATE_USER_NAME"/><field name="CREATE_TIME"/><field name="MODIFY_TIME"/><field name="CREATE_DEPT_ID"/><field name="CREATE_DEPT_NAME"/><field name="APPLY_USER_ID"/><field name="STATE"/><field name="FLOW_STEP"/><field name="PROCESS_INSTANCE_ID"/><field name="FLOW_STATE"/><field name="FULLTEXT_STATE"/><field name="DELETE_TIME"/><field name="DELETE_STATE"/><field name="SECURITY_CODE"/><field name="FILE_COUNT"/><field name="ITEM_COUNT"/><field name="JOB_TITLE"/><field name="DEPT_ID"/><parameter name="formId" type="String" default-value="-1"/></dataset></datasource><paper type="A4" left-margin="28" right-margin="28"
    top-margin="57" bottom-margin="43" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="portrait" html-report-align="left" bg-image="http://192.168.100.66//static/images/planFormStatistics.jpg" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/borrow_approval_hn.ureport 2.xml

New file
@@ -0,0 +1,16 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[利用人次]]></simple-value></cell><cell expand="None" name="B1" row="1" col="2" col-span="3"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[2]]></simple-value></cell><cell expand="None" name="E1" row="1" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[人次]]></simple-value></cell><cell expand="None" name="A2" row="2" col="1"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[利用份次]]></simple-value></cell><cell expand="None" name="B2" row="2" col="2" col-span="3"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[2]]></simple-value></cell><cell expand="None" name="E2" row="2" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[份次]]></simple-value></cell><cell expand="None" name="A3" row="3" col="1"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[利用件次]]></simple-value></cell><cell expand="None" name="B3" row="3" col="2" col-span="3"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[20]]></simple-value></cell><cell expand="None" name="E3" row="3" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[件次]]></simple-value></cell><cell expand="None" name="A4" row="4" col="1" row-span="3"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[纸质资料复制量]]></simple-value></cell><cell expand="None" name="B4" row="4" col="2"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[份次]]></simple-value></cell><cell expand="None" name="C4" row="4" col="3" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[0]]></simple-value></cell><cell expand="None" name="E4" row="4" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（份）]]></simple-value></cell><cell expand="None" name="B5" row="5" col="2"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[报告]]></simple-value></cell><cell expand="None" name="C5" row="5" col="3" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[0]]></simple-value></cell><cell expand="None" name="E5" row="5" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（页）]]></simple-value></cell><cell expand="None" name="B6" row="6" col="2"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[图件]]></simple-value></cell><cell expand="None" name="C6" row="6" col="3" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[0]]></simple-value></cell><cell expand="None" name="E6" row="6" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（幅）]]></simple-value></cell><cell expand="None" name="A7" row="7" col="1" row-span="4"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[电子数据复制量]]></simple-value></cell><cell expand="None" name="B7" row="7" col="2" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[总量]]></simple-value></cell><cell expand="None" name="C7" row="7" col="3"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[份次]]></simple-value></cell><cell expand="None" name="D7" row="7" col="4"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[0]]></simple-value></cell><cell expand="None" name="E7" row="7" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（份）]]></simple-value></cell><cell expand="None" name="C8" row="8" col="3"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[数据量]]></simple-value></cell><cell expand="None" name="D8" row="8" col="4"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[0.000000]]></simple-value></cell><cell expand="None" name="E8" row="8" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（GB）]]></simple-value></cell><cell expand="None" name="B9" row="9" col="2" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[图文数字化]]></simple-value></cell><cell expand="None" name="C9" row="9" col="3"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[份次]]></simple-value></cell><cell expand="None" name="D9" row="9" col="4"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[0]]></simple-value></cell><cell expand="None" name="E9" row="9" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（份）]]></simple-value></cell><cell expand="None" name="C10" row="10" col="3"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[数据量]]></simple-value></cell><cell expand="None" name="D10" row="10" col="4"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[0.000000]]></simple-value></cell><cell expand="None" name="E10" row="10" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（GB）]]></simple-value></cell><row row-number="1" height="26"/><row row-number="2" height="19"/><row row-number="3" height="19"/><row row-number="4" height="19"/><row row-number="5" height="19"/><row row-number="6" height="19"/><row row-number="7" height="19"/><row row-number="8" height="19"/><row row-number="9" height="19"/><row row-number="10" height="19"/><column col-number="1" width="105"/><column col-number="2" width="75"/><column col-number="3" width="53"/><column col-number="4" width="47"/><column col-number="5" width="64"/><footer  font-family="宋体" font-size="10" forecolor="0,0,0" margin="23"><center><![CDATA["第"+page()+"页,共"+pages()+"页"]]></center></footer><datasource name="内置数据源" type="buildin"><dataset name="table2" type="sql"><sql><![CDATA[SELECT
    ARCHIVAL_CODE,
    FILE_TITLE,
    ITEM_TITLE，
    SECURITY_CLASSIFICATION，
    ITEM_NUMBER,
    SECURITY_PAGE_NUM,
    case when ELECTRONIC = '1' and AGREE = '1' then '√'
    else '' end as ELECTRONIC,
    case when PAPER = '1' and AGREE = '1' then '√'
    else '' end as PAPER,
    case when ORIGINAL = '1' and AGREE = '1' then '√'
    else '' end as ORIGINAL
    FROM UTL_BORROW_DETAIL WHERE FORM_ID = (:formId)]]></sql><field name="ARCHIVAL_CODE"/><field name="FILE_TITLE"/><field name="ITEM_TITLE"/><field name="SECURITY_CLASSIFICATION"/><field name="ITEM_NUMBER"/><field name="SECURITY_PAGE_NUM"/><field name="ELECTRONIC"/><field name="PAPER"/><field name="ORIGINAL"/><parameter name="formId" type="String" default-value="-1"/></dataset><dataset name="table3" type="sql"><sql><![CDATA[select * from UTL_BORROW_FORM where FORM_ID =(:formId)]]></sql><field name="FORM_ID"/><field name="APPLY_CODE"/><field name="BORROW_TYPE"/><field name="BORROW_USER_ID"/><field name="BORROW_USER_NAME"/><field name="POST_CODE"/><field name="CERTIFICATE_NUMBER"/><field name="TEL_NUMBER"/><field name="BORROW_TEL"/><field name="BORROW_DATE"/><field name="BORROW_VALID_DATE"/><field name="BORROW_PURPOSE"/><field name="CREATE_USER_ID"/><field name="CREATE_USER_NAME"/><field name="CREATE_TIME"/><field name="MODIFY_TIME"/><field name="CREATE_DEPT_ID"/><field name="CREATE_DEPT_NAME"/><field name="REMARK"/><field name="STATE"/><field name="SECURITY_CLASSIFICATION"/><field name="DEPT_NAME"/><field name="DEPT_ADDRESS"/><field name="FULLTEXT_STATE"/><field name="FLOW_STATE"/><field name="PROCESS_INSTANCE_ID"/><field name="FLOW_STEP"/><field name="SECURITY_CODE"/><field name="DELETE_STATE"/><field name="DELETE_TIME"/><field name="FILE_COUNT"/><field name="ITEM_COUNT"/><parameter name="formId" type="String" default-value="-1"/></dataset></datasource><paper type="A4" left-margin="28" right-margin="28"
    top-margin="57" bottom-margin="43" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="portrait" html-report-align="left" bg-image="http://192.168.100.66//static/images/planFormStatistics.jpg" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/borrow_approval_hn.ureport.xml

New file
@@ -0,0 +1,23 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" col-span="13"><cell-style font-size="14" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"></cell-style><simple-value><![CDATA[地质资料借阅申请表]]></simple-value></cell><cell expand="None" name="A2" row="2" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人]]></simple-value></cell><cell expand="None" name="D2" row="2" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_USER_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G2" row="2" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[电话]]></simple-value></cell><cell expand="None" name="I2" row="2" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_TEL" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A3" row="3" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[所在部门]]></simple-value></cell><cell expand="None" name="D3" row="3" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="DEPT_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A4" row="4" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请日期]]></simple-value></cell><cell expand="None" name="D4" row="4" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_DATE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G4" row="4" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[归还时间]]></simple-value></cell><cell expand="None" name="I4" row="4" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[□1个月  □就地借阅]]></simple-value></cell><cell expand="None" name="A5" row="5" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料用途]]></simple-value></cell><cell expand="None" name="D5" row="5" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="BORROW_PURPOSE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A6" row="6" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料密级]]></simple-value></cell><cell expand="None" name="D6" row="6" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[□绝密级   □机密级   □秘密级    □工作秘密]]></simple-value></cell><cell expand="None" name="A7" row="7" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[档号]]></simple-value></cell><cell expand="None" name="D7" row="7" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[文件题名]]></simple-value></cell><cell expand="None" name="G7" row="7" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[电子]]></simple-value></cell><cell expand="None" name="H7" row="7" col="8"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[纸质]]></simple-value></cell><cell expand="None" name="I7" row="7" col="9"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[调阅原件]]></simple-value></cell><cell expand="None" name="J7" row="7" col="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[密级]]></simple-value></cell><cell expand="None" name="K7" row="7" col="11"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[涉密页码]]></simple-value></cell><cell expand="None" name="L7" row="7" col="12" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[备注]]></simple-value></cell><cell expand="Down" name="A8" row="8" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ARCHIVAL_CODE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="D8" row="8" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ITEM_TITLE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="G8" row="8" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ELECTRONIC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="H8" row="8" col="8"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="PAPER" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="I8" row="8" col="9"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ORIGINAL" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="J8" row="8" col="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="SECURITY_CLASSIFICATION" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="K8" row="8" col="11"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="SECURITY_PAGE_NUM" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="L8" row="8" col="12" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A9" row="9" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人承诺]]></simple-value></cell><cell expand="None" name="D9" row="9" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[  1.本人申请的资料严格按照本表中填写的用途使用，不向第三方提供，不以任何
形式在互联网上传播。
  2.严格按照局保密规定要求保管、使用（如：复印的，填写《涉密载体内部/送外
印制审批表》（见局《涉密载体印制保密管理规定》）履行审批手续；导入涉密计算
机,填写《涉密计算机信息输入审批表》（见局《信息安全保密操作规程》）履行
审批手 续）。
  3.对因本人所借阅的资料造成的失泄密承担全部责任，接收并配合保密检查。
  4.本人对申请表填写的内容的真实性负责]]></simple-value></cell><cell expand="None" name="A10" row="10" col="1" row-span="2" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人所在
部门负责人]]></simple-value></cell><cell expand="None" name="D10" row="10" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（工作秘密、秘密级、机密级审核，绝密级审核；复制移交外单位审核）]]></simple-value></cell><cell expand="None" name="D11" row="11" col="4" col-span="10"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A12" row="12" col="1" row-span="2" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[项目管理/
科学技术处
负责人]]></simple-value></cell><cell expand="None" name="D12" row="12" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（绝密级审核）]]></simple-value></cell><cell expand="None" name="D13" row="13" col="4" col-span="10"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A14" row="14" col="1" row-span="2" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[局领导]]></simple-value></cell><cell expand="None" name="D14" row="14" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[（绝密级审批；复制移交外单位审批）]]></simple-value></cell><cell expand="None" name="D15" row="15" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><row row-number="1" height="26" band="title"/><row row-number="2" height="27" band="title"/><row row-number="3" height="26" band="title"/><row row-number="4" height="25" band="title"/><row row-number="5" height="29" band="title"/><row row-number="6" height="29" band="title"/><row row-number="7" height="26" band="title"/><row row-number="8" height="25"/><row row-number="9" height="152" band="summary"/><row row-number="10" height="33" band="summary"/><row row-number="11" height="33" band="summary"/><row row-number="12" height="22" band="summary"/><row row-number="13" height="42" band="summary"/><row row-number="14" height="23" band="summary"/><row row-number="15" height="50" band="summary"/><column col-number="1" width="34"/><column col-number="2" width="47"/><column col-number="3" width="15"/><column col-number="4" width="40"/><column col-number="5" width="64"/><column col-number="6" width="60"/><column col-number="7" width="50"/><column col-number="8" width="44"/><column col-number="9" width="44"/><column col-number="10" width="43"/><column col-number="11" width="45"/><column col-number="12" width="25"/><column col-number="13" width="28"/><footer  font-family="宋体" font-size="10" forecolor="0,0,0" margin="23"><center><![CDATA["第"+page()+"页,共"+pages()+"页"]]></center></footer><datasource name="内置数据源" type="buildin"><dataset name="table2" type="sql"><sql><![CDATA[SELECT
 *,
    case when ELECTRONIC = '1' and AGREE = '1' then '√'
    else '' end as ELECTRONIC,
    case when PAPER = '1' and AGREE = '1' then '√'
    else '' end as PAPER,
    case when ORIGINAL = '1' and AGREE = '1' then '√'
    else '' end as ORIGINAL
    FROM UTL_BORROW_DETAIL WHERE FORM_ID = (:formId)]]></sql><field name="DETAIL_ID"/><field name="FORM_ID"/><field name="FILE_ID"/><field name="ITEM_ID"/><field name="ARCHIVAL_CODE"/><field name="ITEM_NUMBER"/><field name="FILE_TITLE"/><field name="ITEM_TITLE"/><field name="BORROW_TYPE"/><field name="AGREE"/><field name="SECURITY_CLASSIFICATION"/><field name="SECURITY_PAGE_NUM"/><field name="CREATE_USER_ID"/><field name="CREATE_USER_NAME"/><field name="MODIFY_TIME"/><field name="CREATE_TIME"/><field name="CREATE_DEPT_NAME"/><field name="CREATE_DEPT_ID"/><field name="ELECTRONIC"/><field name="PAPER"/><field name="ORIGINAL"/><field name="PAPER_BORROW"/><field name="ITEM_CODE"/><field name="ELECTRONIC"/><field name="PAPER"/><field name="ORIGINAL"/><parameter name="formId" type="String" default-value="-1"/></dataset><dataset name="table3" type="sql"><sql><![CDATA[SELECT
 *
    FROM UTL_BORROW_FORM WHERE FORM_ID = (:formId)]]></sql><field name="FORM_ID"/><field name="APPLY_CODE"/><field name="BORROW_TYPE"/><field name="BORROW_USER_ID"/><field name="BORROW_USER_NAME"/><field name="POST_CODE"/><field name="CERTIFICATE_NUMBER"/><field name="TEL_NUMBER"/><field name="BORROW_TEL"/><field name="BORROW_DATE"/><field name="BORROW_VALID_DATE"/><field name="BORROW_PURPOSE"/><field name="CREATE_USER_ID"/><field name="CREATE_USER_NAME"/><field name="CREATE_TIME"/><field name="MODIFY_TIME"/><field name="CREATE_DEPT_ID"/><field name="CREATE_DEPT_NAME"/><field name="REMARK"/><field name="STATE"/><field name="SECURITY_CLASSIFICATION"/><field name="DEPT_NAME"/><field name="DEPT_ADDRESS"/><field name="FULLTEXT_STATE"/><field name="FLOW_STATE"/><field name="PROCESS_INSTANCE_ID"/><field name="FLOW_STEP"/><field name="SECURITY_CODE"/><field name="DELETE_STATE"/><field name="DELETE_TIME"/><field name="FILE_COUNT"/><field name="ITEM_COUNT"/><field name="ID_CARD"/><field name="UTILIZATION_METHOD"/><field name="PAPER_BORROW"/><parameter name="formId" type="String" default-value="-1"/></dataset></datasource><paper type="A4" left-margin="28" right-margin="28"
    top-margin="57" bottom-margin="43" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="portrait" html-report-align="left" bg-image="http://192.168.100.66//static/images/planFormStatistics.jpg" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/borrowing_approval_form.ureport.xml

New file
@@ -0,0 +1,7 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" col-span="4"><cell-style font-size="25" forecolor="0,0,0" align="center" valign="middle"></cell-style><simple-value><![CDATA[地勘公司内部资料借阅审批表]]></simple-value></cell><cell expand="None" name="A2" row="2" col="1"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请单位]]></simple-value></cell><cell expand="Down" name="B2" row="2" col="2"><cell-style font-size="13" forecolor="0,0,0" font-family="黑体" wrap-compute="false" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="借阅人数据" aggregate="group" property="DEPT_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="C2" row="2" col="3"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人]]></simple-value></cell><cell expand="Down" name="D2" row="2" col="4"><cell-style font-size="13" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="借阅人数据" aggregate="group" property="CREATE_USER_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A3" row="3" col="1"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[分子公司
负责人签字]]></simple-value></cell><cell expand="None" name="B3" row="3" col="2"><cell-style font-size="13" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="C3" row="3" col="3"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[分管领导签字]]></simple-value></cell><cell expand="None" name="D3" row="3" col="4"><cell-style font-size="13" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A4" row="4" col="1"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[技术资源
名称]]></simple-value></cell><cell expand="None" name="B4" row="4" col="2"><cell-style font-size="13" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="C4" row="4" col="3"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料用途]]></simple-value></cell><cell expand="Down" name="D4" row="4" col="4"><cell-style font-size="13" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="借阅人数据" aggregate="group" property="PROCESSING_PURPOSE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A5" row="5" col="1" col-span="4"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料详细清单]]></simple-value></cell><cell expand="None" name="A6" row="6" col="1"><cell-style font-size="15" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[序号]]></simple-value></cell><cell expand="None" name="B6" row="6" col="2"><cell-style font-size="15" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[省馆档号]]></simple-value></cell><cell expand="None" name="C6" row="6" col="3"><cell-style font-size="15" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[案卷题名]]></simple-value></cell><cell expand="None" name="D6" row="6" col="4"><cell-style font-size="15" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[文件题名]]></simple-value></cell><cell expand="None" name="A7" row="7" col="1" left-cell="B7"><cell-style font-size="13" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[row() - 6]]></expression-value></cell><cell expand="Down" name="B7" row="7" col="2" left-cell="root"><cell-style font-size="13" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="借阅资料明细" aggregate="select" property="ARCHIVAL_CODE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="C7" row="7" col="3"><cell-style font-size="13" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="借阅资料明细" aggregate="select" property="FILE_TITLE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="D7" row="7" col="4"><cell-style font-size="13" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="借阅资料明细" aggregate="select" property="ITEM_TITLE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A8" row="8" col="1" row-span="2"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[生产技术部
部长签字]]></simple-value></cell><cell expand="None" name="B8" row="8" col="2" col-span="3"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="B9" row="9" col="2"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="C9" row="9" col="3" col-span="2"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[日期：    年  月  日]]></simple-value></cell><cell expand="None" name="A10" row="10" col="1" row-span="2"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[总工程师
签字]]></simple-value></cell><cell expand="None" name="B10" row="10" col="2" col-span="3"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="B11" row="11" col="2"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="C11" row="11" col="3" col-span="2"><cell-style font-size="15" forecolor="0,0,0" font-family="黑体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[日期：    年  月  日]]></simple-value></cell><row row-number="1" height="60" band="title"/><row row-number="2" height="60"/><row row-number="3" height="60"/><row row-number="4" height="60"/><row row-number="5" height="38"/><row row-number="6" height="60"/><row row-number="7" height="60"/><row row-number="8" height="90"/><row row-number="9" height="19"/><row row-number="10" height="90"/><row row-number="11" height="19"/><column col-number="1" width="113"/><column col-number="2" width="113"/><column col-number="3" width="113"/><column col-number="4" width="113"/><datasource name="内置数据源" type="buildin"><dataset name="借阅人数据" type="sql"><sql><![CDATA[select * from UTL_PROCESSING_FORM where form_id=:formId]]></sql><field name="FORM_ID"/><field name="APPLY_CODE"/><field name="PROCESSING_TYPE"/><field name="PROCESSING_USER_ID"/><field name="PROCESSING_USER_NAME"/><field name="POST_CODE"/><field name="CERTIFICATE_NUMBER"/><field name="TEL_NUMBER"/><field name="PROCESSING_TEL"/><field name="PROCESSING_DATE"/><field name="PROCESSING_VALID_DATE"/><field name="PROCESSING_PURPOSE"/><field name="REMARK"/><field name="STATE"/><field name="SECURITY_CLASSIFICATION"/><field name="DEPT_NAME"/><field name="DEPT_ADDRESS"/><field name="PROJECT_TYPE"/><field name="PROJECT_NAME"/><field name="CREATE_USER_ID"/><field name="CREATE_USER_NAME"/><field name="CREATE_TIME"/><field name="MODIFY_TIME"/><field name="CREATE_DEPT_ID"/><field name="CREATE_DEPT_NAME"/><field name="SECURITY_CODE"/><field name="DELETE_STATE"/><field name="DELETE_TIME"/><field name="FULLTEXT_STATE"/><field name="FLOW_STATE"/><field name="PROCESS_INSTANCE_ID"/><field name="FLOW_STEP"/><field name="FILE_COUNT"/><field name="ITEM_COUNT"/><field name="ID_CARD"/><field name="OTHER_APPLY"/><field name="SOURCE_FILE_COUNT"/><field name="ARCHIVE_FILE_COUNT"/><field name="ORIGINAL_FILE_COUNT"/><field name="OLD_ID"/><field name="PROCESS_REMARK"/><parameter name="formId" type="String" default-value="1937783420629078018"/></dataset><dataset name="借阅资料明细" type="sql"><sql><![CDATA[select * from UTL_PROCESSING_DETAIL where FORM_ID=:formId]]></sql><field name="DETAIL_ID"/><field name="FORM_ID"/><field name="FILE_ID"/><field name="ITEM_ID"/><field name="ARCHIVAL_CODE"/><field name="ITEM_NUMBER"/><field name="FILE_TITLE"/><field name="ITEM_TITLE"/><field name="PROCESSING_TYPE"/><field name="DOWNLOAD"/><field name="PRINT"/><field name="AGREE"/><field name="SECURITY_CLASSIFICATION"/><field name="SECURITY_PAGE_NUM"/><field name="CREATE_USER_ID"/><field name="CREATE_USER_NAME"/><field name="CREATE_TIME"/><field name="CREATE_DEPT_ID"/><field name="CREATE_DEPT_NAME"/><field name="MODIFY_TIME"/><field name="SECURITY_CODE"/><field name="DEPT_NAME"/><field name="OLD_ID"/><field name="DELETE_SECURITY_PAGE"/><parameter name="formId" type="String" default-value="1930173614487826433"/></dataset></datasource><paper type="A4" left-margin="90" right-margin="90"
    top-margin="72" bottom-margin="72" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="portrait" html-report-align="left" bg-image="" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/catAjjxx_confluence_ureport.xml

New file
@@ -0,0 +1,6 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料档号]]></simple-value></cell><cell expand="None" name="B1" row="1" col="2" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[类别]]></simple-value></cell><cell expand="None" name="C1" row="1" col="3" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料名称]]></simple-value></cell><cell expand="None" name="D1" row="1" col="4" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[汇交人]]></simple-value></cell><cell expand="None" name="E1" row="1" col="5" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[形成日期]]></simple-value></cell><cell expand="None" name="F1" row="1" col="6" col-span="9"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[每份报告内容]]></simple-value></cell><cell expand="None" name="O1" row="1" col="15" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[密级或保护
期限]]></simple-value></cell><cell expand="None" name="P1" row="1" col="16" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[成果涉密件数]]></simple-value></cell><cell expand="None" name="Q1" row="1" col="17" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[成果电子容量]]></simple-value></cell><cell expand="None" name="R1" row="1" col="18" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[湘地资汇编号]]></simple-value></cell><cell expand="None" name="S1" row="1" col="19" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[汇交日期]]></simple-value></cell><cell expand="None" name="T1" row="1" col="20" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[接收人]]></simple-value></cell><cell expand="None" name="U1" row="1" col="21" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[分类]]></simple-value></cell><cell expand="None" name="V1" row="1" col="22" col-span="4"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[原始资料汇交情况]]></simple-value></cell><cell expand="None" name="F2" row="2" col="6"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[正文(册)]]></simple-value></cell><cell expand="None" name="G2" row="2" col="7"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[附图（张）]]></simple-value></cell><cell expand="None" name="H2" row="2" col="8"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[图册]]></simple-value></cell><cell expand="None" name="I2" row="2" col="9"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[附表（册）]]></simple-value></cell><cell expand="None" name="J2" row="2" col="10"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[附件（册）]]></simple-value></cell><cell expand="None" name="K2" row="2" col="11"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[其他（册）]]></simple-value></cell><cell expand="None" name="L2" row="2" col="12"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[数据库及软件]]></simple-value></cell><cell expand="None" name="M2" row="2" col="13"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[审批类(册)]]></simple-value></cell><cell expand="None" name="N2" row="2" col="14"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[光盘（张）]]></simple-value></cell><cell expand="None" name="V2" row="2" col="22"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[文件
件数]]></simple-value></cell><cell expand="None" name="W2" row="2" col="23"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[容量]]></simple-value></cell><cell expand="None" name="X2" row="2" col="24"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[密级]]></simple-value></cell><cell expand="None" name="Y2" row="2" col="25"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[涉密
件数]]></simple-value></cell><cell expand="Down" name="A3" row="3" col="1" left-cell="C3"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="DH" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="B3" row="3" col="2" left-cell="C3"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="Down" name="C3" row="3" col="3" left-cell="root" top-cell="root"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="ZLMC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="D3" row="3" col="4"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="HJRMC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="E3" row="3" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="XCSJ" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="F3" row="3" col="6"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="ZWDZJS" order="none" mapping-type="simple"></dataset-value><condition-property-item name="ss"><cell-style for-condition="true" font-size-scope="cell" forecolor-scope="cell" font-family-scope="cell" bgcolor-scope="cell" bold-scope="cell" italic-scope="cell" underline-scope="cell" align-scope="cell" valign-scope="cell"></cell-style></condition-property-item></cell><cell expand="Down" name="G3" row="3" col="7"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="FTDZJS" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="H3" row="3" col="8"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="TDZJS" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="I3" row="3" col="9"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="FBDZJS" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="J3" row="3" col="10"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="FJDZJS" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="K3" row="3" col="11"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="QTDZJS" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="L3" row="3" col="12"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="SJKDZJS" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="M3" row="3" col="13"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="SPDZJS" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="N3" row="3" col="14"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="DMTDZJS" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="O3" row="3" col="15"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="MJ" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="P3" row="3" col="16"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="Q3" row="3" col="17"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="R3" row="3" col="18"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="Down" name="S3" row="3" col="19" left-cell="C3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="JSRQ" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="T3" row="3" col="20" left-cell="C3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="YSR" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="U3" row="3" col="21" left-cell="C3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="V3" row="3" col="22" left-cell="C3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="W3" row="3" col="23" left-cell="C3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="X3" row="3" col="24" left-cell="C3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="Y3" row="3" col="25" left-cell="C3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><row row-number="1" height="18" band="title"/><row row-number="2" height="19" band="title"/><row row-number="3" height="18"/><column col-number="1" width="35"/><column col-number="2" width="41"/><column col-number="3" width="101"/><column col-number="4" width="52"/><column col-number="5" width="53"/><column col-number="6" width="52"/><column col-number="7" width="52"/><column col-number="8" width="52"/><column col-number="9" width="52"/><column col-number="10" width="52"/><column col-number="11" width="52"/><column col-number="12" width="52"/><column col-number="13" width="52"/><column col-number="14" width="52"/><column col-number="15" width="62"/><column col-number="16" width="69"/><column col-number="17" width="64"/><column col-number="18" width="70"/><column col-number="19" width="49"/><column col-number="20" width="34"/><column col-number="21" width="36"/><column col-number="22" width="41"/><column col-number="23" width="41"/><column col-number="24" width="41"/><column col-number="25" width="41"/><datasource name="内置数据源" type="buildin"><dataset name="ajjxx" type="sql"><sql><![CDATA[select * from cat_file_ajjxx]]></sql><field name="ID"/><field name="ZLLY"/><field name="HJRDH"/><field name="SGDH"/><field name="DH"/><field name="BZSDH"/><field name="HJZSDW"/><field name="BSSJ"/><field name="ZSDWAJH"/><field name="JSRQ"/><field name="JSDWMC"/><field name="BGDWMC"/><field name="ZLMC"/><field name="FZMC"/><field name="BZZ"/><field name="ZLLB"/><field name="ZLLBDM"/><field name="YZ"/><field name="GZCD"/><field name="QTGZCD"/><field name="GZFF"/><field name="SPSJ"/><field name="SMQK"/><field name="MJ"/><field name="SFBH"/><field name="BHQ"/><field name="BHSX"/><field name="HJPZH"/><field name="FZRQ"/><field name="FBRQ"/><field name="GJZ"/><field name="NRZY"/><field name="BGQX"/><field name="BZ"/><field name="HJRMC"/><field name="HJRDZ"/><field name="HJRTYSHXYDM"/><field name="HJRYB"/><field name="HJRLXR"/><field name="HJRLXFS"/><field name="HJRDZYX"/><field name="QSJD_FX"/><field name="QSJD_DU"/><field name="QSJD_FEN"/><field name="QSJD_MIAO"/><field name="ZZJD_FX"/><field name="ZZJD_DU"/><field name="ZZJD_FEN"/><field name="ZZJD_MIAO"/><field name="QSWD_FX"/><field name="QSWD_DU"/><field name="QSWD_FEN"/><field name="QSWD_MIAO"/><field name="ZZWD_FX"/><field name="ZZWD_DU"/><field name="ZZWD_FEN"/><field name="ZZWD_MIAO"/><field name="GDZB"/><field name="DLZBX"/><field name="XZQMC"/><field name="XZQDM"/><field name="KCDM"/><field name="KCMC"/><field name="DDGZWZ"/><field name="CKD"/><field name="ZYKZ"/><field name="CKSD"/><field name="CYLX"/><field name="ZYCGJS"/><field name="YDZWJGSJBB"/><field name="YJHJ"/><field name="RJHJ"/><field name="TJXTKZKTYSM"/><field name="QTSM"/><field name="ZWZZJS"/><field name="SPZZJS"/><field name="FTZZJS"/><field name="FBZZJS"/><field name="FJZZJS"/><field name="QTZJS"/><field name="HDS"/><field name="ZWDZJS"/><field name="SPDZJS"/><field name="FTDZJS"/><field name="FBDZJS"/><field name="FJDZJS"/><field name="RJDZJS"/><field name="SJKDZJS"/><field name="DMTDZJS"/><field name="QTDZJS"/><field name="CGZLSJL"/><field name="CGZLDZWJZS"/><field name="CGZLDZJS"/><field name="CGZLZZJS"/><field name="CGZLDZWJJZS"/><field name="DZZJS"/><field name="CZZJS"/><field name="GZZJS"/><field name="TZZJS"/><field name="YZZJS"/><field name="SZZJS"/><field name="LZZJS"/><field name="XZZJS"/><field name="ZZZJS"/><field name="WZZJS"/><field name="DDZJS"/><field name="CDZJS"/><field name="GDZJS"/><field name="TDZJS"/><field name="YDZJS"/><field name="SDZJS"/><field name="LDZJS"/><field name="XDZJS"/><field name="ZDZJS"/><field name="WDZJS"/><field name="YSDZSJL"/><field name="SWDH"/><field name="SWZLLB"/><field name="SWZLBCDW"/><field name="ZKSL"/><field name="ZJC"/><field name="YXZSL"/><field name="YXIZSL"/><field name="BBZSL"/><field name="YPZSL"/><field name="GPZSL"/><field name="BPZSL"/><field name="QTSWMC"/><field name="SWBZ"/><field name="QTSWSL"/><field name="XMKYQXZ"/><field name="XMKYQLX"/><field name="XMKYQMC"/><field name="XMKYQBH"/><field name="QSSJ"/><field name="ZZSJ"/><field name="XMZGJGMC"/><field name="XMCDDWKYQR"/><field name="XMFZR"/><field name="ZJLY"/><field name="XMXXSM"/><field name="XCDWMC"/><field name="XZDWDZ"/><field name="XZDWYB"/><field name="XZDWXYDM"/><field name="XZDWYX"/><field name="XZDWLXR"/><field name="XZDWLXRDH"/><field name="YSJZSJ"/><field name="SLR"/><field name="SLSJ"/><field name="CJSJ"/><field name="ZLZT"/><field name="ZLUZT"/><field name="FBZT"/><field name="YSR"/><field name="YSWSJ"/><field name="PZXXLRZT"/><field name="FBFSJ"/><field name="FBR"/><field name="ZWYDZJS"/><field name="SPYDZJS"/><field name="FTYDZJS"/><field name="FBYDZJS"/><field name="FJYDZJS"/><field name="RJYDZJS"/><field name="SJKYDZJS"/><field name="DMTYDZJS"/><field name="QTYDZJS"/><field name="ZWCDDZJS"/><field name="SPCDDZJS"/><field name="FTCDDZJS"/><field name="FBCDDZJS"/><field name="FJCDDZJS"/><field name="RJCDDZJS"/><field name="SJKCDDZJS"/><field name="DMTCDDZJS"/><field name="QTCDDZJS"/><field name="QTZZJS"/><field name="YSZLDZJS"/><field name="YSZLSJL"/><field name="YSZLDZWJZS"/><field name="YSZLDZWJJZS"/><field name="YSZLZZJS"/><field name="create_dept_name"/><field name="create_dept_id"/><field name="modify_time"/><field name="create_time"/><field name="create_user_name"/><field name="create_user_id"/><field name="delete_state"/><field name="fulltext_state"/><field name="XCSJ"/><field name="SPJG"/><field name="XCDWSHXYDM"/><field name="DLWZS"/></dataset></datasource><paper type="A4" left-margin="90" right-margin="90"
    top-margin="72" bottom-margin="72" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="landscape" html-report-align="left" bg-image="" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/catAjjxx_formingUnitStatistics.ureport.xml

New file
@@ -0,0 +1,17 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[形成单位]]></simple-value></cell><cell expand="None" name="B1" row="1" col="2" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[案卷数量]]></simple-value></cell><cell expand="None" name="C1" row="1" col="3" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[成果数量]]></simple-value></cell><cell expand="None" name="D1" row="1" col="4" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[原始数量]]></simple-value></cell><cell expand="Down" name="A3" row="3" col="1" left-cell="B3"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="HJRMC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="B3" row="3" col="2" left-cell="root" top-cell="root"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="ajnum" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="C3" row="3" col="3"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="jnnum" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="D3" row="3" col="4"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="ysnum" order="none" mapping-type="simple"></dataset-value></cell><row row-number="1" height="18" band="title"/><row row-number="2" height="19" band="title"/><row row-number="3" height="18"/><column col-number="1" width="68"/><column col-number="2" width="122"/><column col-number="3" width="80"/><column col-number="4" width="80"/><datasource name="内置数据源" type="buildin"><dataset name="ajjxx" type="sql"><sql><![CDATA[${
 "select HJRMC,sum(ajnum) ajnum,sum(jnnum) jnnum,sum(ysnum) ysnum from( select HJRMC,count(HJRMC) ajnum,0 jnnum,0 ysnum from cat_file_ajjxx where 1=1 "
  +(param("startDate")!=null && param("startDate")!="" ? " and JSRQ > \'"+param("startDate")+"\'":" ")
  +(param("endDate")!=null && param("endDate")!="" ? " and JSRQ < \'"+param("endDate")+"\'":" ")
  +(param("deptName")!=null && param("deptName")!="" ? " and XCDWMC = \'"+param("deptName")+"\'":" ") 
  +" group by HJRMC union all select a.HJRMC,0 ajnum,count(b.id) jnnum,0 ysnum from cat_file_ajjxx a,cat_item_yswjxx b where  a.ID = b.AJ_ID"
  +(param("startDate")!=null && param("startDate")!="" ? " and a.JSRQ > \'"+param("startDate")+"\'":" ")
  +(param("endDate")!=null && param("endDate")!="" ? " and a.JSRQ < \'"+param("endDate")+"\'":" ")
  +(param("deptName")!=null && param("deptName")!="" ? " and a.XCDWMC = \'"+param("deptName")+"\'":" ") 
  +" group by a.HJRMC union all select a.HJRMC,0 ajnum, 0 jnnum,count(b.id) ysnum from cat_file_ajjxx a,cat_item_yswjxx b where a.ID = b.AJ_ID "
  +(param("startDate")!=null && param("startDate")!="" ? " and a.JSRQ > \'"+param("startDate")+"\'":" ")
  +(param("endDate")!=null && param("endDate")!="" ? " and a.JSRQ < \'"+param("endDate")+"\'":" ")
  +(param("deptName")!=null && param("deptName")!="" ? " and a.XCDWMC = \'"+param("deptName")+"\'":" ") 
  +" group by a.HJRMC) t group by HJRMC"
}]]></sql><field name="HJRMC"/><field name="ajnum"/><field name="jnnum"/><field name="ysnum"/><parameter name="deptName" type="String" default-value=""/><parameter name="startDate" type="String" default-value=""/><parameter name="endDate" type="String" default-value=""/></dataset></datasource><paper type="A4" left-margin="90" right-margin="90"
    top-margin="72" bottom-margin="72" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="landscape" html-report-align="left" bg-image="" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/catAjjxx_hjqktj.ureport.xml

New file
@@ -0,0 +1,19 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[类型]]></simple-value></cell><cell expand="None" name="B1" row="1" col="2" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[数量]]></simple-value></cell><cell expand="Down" name="A3" row="3" col="1" left-cell="B3"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="name" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="B3" row="3" col="2" left-cell="root" top-cell="root"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="num" order="none" mapping-type="simple"></dataset-value></cell><row row-number="1" height="18" band="title"/><row row-number="2" height="19" band="title"/><row row-number="3" height="18"/><column col-number="1" width="218"/><column col-number="2" width="63"/><datasource name="内置数据源" type="buildin"><dataset name="ajjxx" type="sql"><sql><![CDATA[SELECT '区域调查' as name , COUNT(*) as num  from cat_file_ajjxx where  ZLLB like '区域%' or ZLLB = '城市地质调查' or ZLLB='其他区域地质调查' 
union all
SELECT '海洋地质调查' as name , COUNT(*) as num from cat_file_ajjxx where  ZLLB like '%海%' or ZLLB = '大陆架地质矿产调查' or ZLLB='极地地质调查' 
union all
SELECT '矿产勘查' as name , COUNT(*) as num from cat_file_ajjxx where  ZLLB like '%矿产勘查%' 
union all
SELECT '水工环地质勘查' as name, COUNT(*) as num from cat_file_ajjxx where  ZLLB like '%地质勘查%'  or ZLLB='天然地震地质调查' or ZLLB='生态地球化学调查'
union all
SELECT '物化遥勘查' as name, COUNT(*) as num from cat_file_ajjxx where  ZLLB='地球物理勘查' or ZLLB='地球化学勘查' or ZLLB='遥感地质调查' or ZLLB='物化探异常查证' or ZLLB ='物化遥勘查'
union all
SELECT '地质科学研究' as name, COUNT(*) as num from cat_file_ajjxx where  ZLLB='地质科学研究' or ZLLB='理论研究' or ZLLB='应用研究' or ZLLB='软科学研究' or ZLLB ='综合研究' or ZLLB ='地质遗迹调查' or ZLLB ='地质公园规划' 
union all
SELECT '技术方法研究' as name, COUNT(*)as num  from cat_file_ajjxx where  ZLLB='标准规范制定' or ZLLB='仪器设备研发' or ZLLB='信息系统建设' or ZLLB='数据库建设' or ZLLB ='其他方法' 
union all
SELECT '自然资源综合调查' as name, COUNT(*) as num from cat_file_ajjxx where  ZLLB='自然资源综合调查' 
union all
SELECT '其他' as name, COUNT(*)as num  from cat_file_ajjxx where  ZLLB='其他' or ZLLB='储量表' or ZLLB='其他地质工作' ]]></sql><field name="name"/><field name="num"/></dataset></datasource><paper type="A4" left-margin="90" right-margin="90"
    top-margin="72" bottom-margin="72" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="landscape" html-report-align="left" bg-image="" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/catAjjxx_ledger_ureport.xml

New file
@@ -0,0 +1,10 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[序号]]></simple-value></cell><cell expand="None" name="B1" row="1" col="2" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[报告名称]]></simple-value></cell><cell expand="None" name="C1" row="1" col="3" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[报告编制单位]]></simple-value></cell><cell expand="None" name="D1" row="1" col="4" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[联系姓名]]></simple-value></cell><cell expand="None" name="E1" row="1" col="5" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[联系电话]]></simple-value></cell><cell expand="None" name="F1" row="1" col="6" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[第一次（新接收）]]></simple-value></cell><cell expand="None" name="H1" row="1" col="8" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[第二次]]></simple-value></cell><cell expand="None" name="J1" row="1" col="10" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[第三次]]></simple-value></cell><cell expand="None" name="L1" row="1" col="12" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[第四次]]></simple-value></cell><cell expand="None" name="N1" row="1" col="14" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[第五次]]></simple-value></cell><cell expand="None" name="P1" row="1" col="16" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[馆内验收人]]></simple-value></cell><cell expand="None" name="Q1" row="1" col="17" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[总修改次数]]></simple-value></cell><cell expand="None" name="R1" row="1" col="18" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[总体验收情况]]></simple-value></cell><cell expand="None" name="F2" row="2" col="6"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[接收时间]]></simple-value></cell><cell expand="None" name="G2" row="2" col="7"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[验收时间]]></simple-value></cell><cell expand="None" name="H2" row="2" col="8"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[接收时间]]></simple-value></cell><cell expand="None" name="I2" row="2" col="9"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[验收时间]]></simple-value></cell><cell expand="None" name="J2" row="2" col="10"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[接收时间]]></simple-value></cell><cell expand="None" name="K2" row="2" col="11"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[验收时间]]></simple-value></cell><cell expand="None" name="L2" row="2" col="12"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[接收时间]]></simple-value></cell><cell expand="None" name="M2" row="2" col="13"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[验收时间]]></simple-value></cell><cell expand="None" name="N2" row="2" col="14"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[接收时间]]></simple-value></cell><cell expand="None" name="O2" row="2" col="15"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[验收时间]]></simple-value></cell><cell expand="Down" name="A3" row="3" col="1" left-cell="B3"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[return row() - 2]]></expression-value></cell><cell expand="Down" name="B3" row="3" col="2" left-cell="root" top-cell="root"><cell-style font-size="10" font-family="微软雅黑" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="ZLMC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="C3" row="3" col="3"><cell-style font-size="10" font-family="微软雅黑" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="XCDWMC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="D3" row="3" col="4"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="HJRMC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="E3" row="3" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="HJRLXFS" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="F3" row="3" col="6" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="ACCEPT_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="4f4c8ba0-86d4-11ef-84e4-01216287ef96" type="property" join="and"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="4f4cb2b0-86d4-11ef-84e4-01216287ef96" type="property" join="and"><value><![CDATA[1]]></value></condition></dataset-value><condition-property-item name="ss"><cell-style for-condition="true" font-size-scope="cell" forecolor-scope="cell" font-family-scope="cell" bgcolor-scope="cell" bold-scope="cell" italic-scope="cell" underline-scope="cell" align-scope="cell" valign-scope="cell"></cell-style></condition-property-item></cell><cell expand="None" name="G3" row="3" col="7" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="CHECK_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="7e44ce20-86d1-11ef-84e4-01216287ef96" type="property" join="and"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="7e44ce21-86d1-11ef-84e4-01216287ef96" type="property" join="and"><value><![CDATA[1]]></value></condition></dataset-value></cell><cell expand="None" name="H3" row="3" col="8" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="ACCEPT_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="5a8614a0-86d4-11ef-84e4-01216287ef96" type="property" join="and"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="5a8614a1-86d4-11ef-84e4-01216287ef96" type="property" join="and"><value><![CDATA[2]]></value></condition></dataset-value></cell><cell expand="None" name="I3" row="3" col="9" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="CHECK_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="79d6ecb0-86d1-11ef-84e4-01216287ef96" type="property" join="and"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="79d6ecb1-86d1-11ef-84e4-01216287ef96" type="property" join="and"><value><![CDATA[2]]></value></condition></dataset-value></cell><cell expand="None" name="J3" row="3" col="10" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="ACCEPT_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="ebc7bfe0-86d4-11ef-84e4-01216287ef96" type="undefined"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="f1779730-86d4-11ef-84e4-01216287ef96" type="undefined" join="and"><value><![CDATA[3]]></value></condition></dataset-value></cell><cell expand="None" name="K3" row="3" col="11" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="CHECK_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="0c5b49c0-86d5-11ef-84e4-01216287ef96" type="undefined"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="10ae0210-86d5-11ef-84e4-01216287ef96" type="undefined" join="and"><value><![CDATA[3]]></value></condition></dataset-value></cell><cell expand="None" name="L3" row="3" col="12" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="ACCEPT_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="15a0f200-86d5-11ef-84e4-01216287ef96" type="undefined"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="1a32af20-86d5-11ef-84e4-01216287ef96" type="undefined" join="and"><value><![CDATA[4]]></value></condition></dataset-value></cell><cell expand="None" name="M3" row="3" col="13" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="CHECK_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="205aeac0-86d5-11ef-84e4-01216287ef96" type="undefined"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="25093090-86d5-11ef-84e4-01216287ef96" type="undefined" join="and"><value><![CDATA[4]]></value></condition></dataset-value></cell><cell expand="None" name="N3" row="3" col="14" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="ACCEPT_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="2a6da700-86d5-11ef-84e4-01216287ef96" type="undefined"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="2f797620-86d5-11ef-84e4-01216287ef96" type="undefined" join="and"><value><![CDATA[5]]></value></condition></dataset-value></cell><cell expand="None" name="O3" row="3" col="15" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="CHECK_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="358920b0-86d5-11ef-84e4-01216287ef96" type="undefined"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="3ab68190-86d5-11ef-84e4-01216287ef96" type="undefined" join="and"><value><![CDATA[5]]></value></condition></dataset-value></cell><cell expand="Down" name="P3" row="3" col="16" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="YSR" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="Q3" row="3" col="17"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="#" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="max" property="TIME" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="c14ce8d0-86cf-11ef-84e4-01216287ef96" type="property"><value><![CDATA[ajjxx.select(id)]]></value></condition></dataset-value></cell><cell expand="None" name="R3" row="3" col="18"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><row row-number="1" height="18" band="headerrepeat"/><row row-number="2" height="19" band="headerrepeat"/><row row-number="3" height="18"/><column col-number="1" width="35"/><column col-number="2" width="122"/><column col-number="3" width="80"/><column col-number="4" width="80"/><column col-number="5" width="74"/><column col-number="6" width="70"/><column col-number="7" width="63"/><column col-number="8" width="58"/><column col-number="9" width="60"/><column col-number="10" width="65"/><column col-number="11" width="66"/><column col-number="12" width="74"/><column col-number="13" width="74"/><column col-number="14" width="74"/><column col-number="15" width="74"/><column col-number="16" width="74"/><column col-number="17" width="74"/><column col-number="18" width="74"/><datasource name="内置数据源" type="buildin"><dataset name="ajjxx" type="sql"><sql><![CDATA[${
 "select * from cat_file_ajjxx where 1=1"+
  (param("title")!=null && param("title")!="" ? " and ZLMC = \'"+param("title")+"\'":" ") 
  +(param("deptName")!=null && param("deptName")!="" ? " and XCDWMC = \'"+param("deptName")+"\'":" ") 
}


]]></sql><field name="ID"/><field name="ZLLY"/><field name="HJRDH"/><field name="SGDH"/><field name="DH"/><field name="BZSDH"/><field name="HJZSDW"/><field name="BSSJ"/><field name="ZSDWAJH"/><field name="JSRQ"/><field name="JSDWMC"/><field name="BGDWMC"/><field name="ZLMC"/><field name="FZMC"/><field name="BZZ"/><field name="ZLLB"/><field name="ZLLBDM"/><field name="YZ"/><field name="GZCD"/><field name="QTGZCD"/><field name="GZFF"/><field name="SPSJ"/><field name="SMQK"/><field name="MJ"/><field name="SFBH"/><field name="BHQ"/><field name="BHSX"/><field name="HJPZH"/><field name="FZRQ"/><field name="FBRQ"/><field name="GJZ"/><field name="NRZY"/><field name="BGQX"/><field name="BZ"/><field name="HJRMC"/><field name="HJRDZ"/><field name="HJRTYSHXYDM"/><field name="HJRYB"/><field name="HJRLXR"/><field name="HJRLXFS"/><field name="HJRDZYX"/><field name="QSJD_FX"/><field name="QSJD_DU"/><field name="QSJD_FEN"/><field name="QSJD_MIAO"/><field name="ZZJD_FX"/><field name="ZZJD_DU"/><field name="ZZJD_FEN"/><field name="ZZJD_MIAO"/><field name="QSWD_FX"/><field name="QSWD_DU"/><field name="QSWD_FEN"/><field name="QSWD_MIAO"/><field name="ZZWD_FX"/><field name="ZZWD_DU"/><field name="ZZWD_FEN"/><field name="ZZWD_MIAO"/><field name="GDZB"/><field name="DLZBX"/><field name="XZQMC"/><field name="XZQDM"/><field name="KCDM"/><field name="KCMC"/><field name="DDGZWZ"/><field name="CKD"/><field name="ZYKZ"/><field name="CKSD"/><field name="CYLX"/><field name="ZYCGJS"/><field name="YDZWJGSJBB"/><field name="YJHJ"/><field name="RJHJ"/><field name="TJXTKZKTYSM"/><field name="QTSM"/><field name="ZWZZJS"/><field name="SPZZJS"/><field name="FTZZJS"/><field name="FBZZJS"/><field name="FJZZJS"/><field name="QTZJS"/><field name="HDS"/><field name="ZWDZJS"/><field name="SPDZJS"/><field name="FTDZJS"/><field name="FBDZJS"/><field name="FJDZJS"/><field name="RJDZJS"/><field name="SJKDZJS"/><field name="DMTDZJS"/><field name="QTDZJS"/><field name="CGZLSJL"/><field name="CGZLDZWJZS"/><field name="CGZLDZJS"/><field name="CGZLZZJS"/><field name="CGZLDZWJJZS"/><field name="DZZJS"/><field name="CZZJS"/><field name="GZZJS"/><field name="TZZJS"/><field name="YZZJS"/><field name="SZZJS"/><field name="LZZJS"/><field name="XZZJS"/><field name="ZZZJS"/><field name="WZZJS"/><field name="DDZJS"/><field name="CDZJS"/><field name="GDZJS"/><field name="TDZJS"/><field name="YDZJS"/><field name="SDZJS"/><field name="LDZJS"/><field name="XDZJS"/><field name="ZDZJS"/><field name="WDZJS"/><field name="YSDZSJL"/><field name="SWDH"/><field name="SWZLLB"/><field name="SWZLBCDW"/><field name="ZKSL"/><field name="ZJC"/><field name="YXZSL"/><field name="YXIZSL"/><field name="BBZSL"/><field name="YPZSL"/><field name="GPZSL"/><field name="BPZSL"/><field name="QTSWMC"/><field name="SWBZ"/><field name="QTSWSL"/><field name="XMKYQXZ"/><field name="XMKYQLX"/><field name="XMKYQMC"/><field name="XMKYQBH"/><field name="QSSJ"/><field name="ZZSJ"/><field name="XMZGJGMC"/><field name="XMCDDWKYQR"/><field name="XMFZR"/><field name="ZJLY"/><field name="XMXXSM"/><field name="XCDWMC"/><field name="XZDWDZ"/><field name="XZDWYB"/><field name="XZDWXYDM"/><field name="XZDWYX"/><field name="XZDWLXR"/><field name="XZDWLXRDH"/><field name="YSJZSJ"/><field name="SLR"/><field name="SLSJ"/><field name="CJSJ"/><field name="ZLZT"/><field name="ZLUZT"/><field name="FBZT"/><field name="YSR"/><field name="YSWSJ"/><field name="PZXXLRZT"/><field name="FBFSJ"/><field name="FBR"/><field name="ZWYDZJS"/><field name="SPYDZJS"/><field name="FTYDZJS"/><field name="FBYDZJS"/><field name="FJYDZJS"/><field name="RJYDZJS"/><field name="SJKYDZJS"/><field name="DMTYDZJS"/><field name="QTYDZJS"/><field name="ZWCDDZJS"/><field name="SPCDDZJS"/><field name="FTCDDZJS"/><field name="FBCDDZJS"/><field name="FJCDDZJS"/><field name="RJCDDZJS"/><field name="SJKCDDZJS"/><field name="DMTCDDZJS"/><field name="QTCDDZJS"/><field name="QTZZJS"/><field name="YSZLDZJS"/><field name="YSZLSJL"/><field name="YSZLDZWJZS"/><field name="YSZLDZWJJZS"/><field name="YSZLZZJS"/><field name="CREATE_DEPT_NAME"/><field name="CREATE_DEPT_ID"/><field name="MODIFY_TIME"/><field name="CREATE_TIME"/><field name="CREATE_USER_NAME"/><field name="CREATE_USER_ID"/><field name="DELETE_STATE"/><field name="FULLTEXT_STATE"/><field name="XCSJ"/><field name="SPJG"/><field name="XCDWSHXYDM"/><field name="DLWZS"/><field name="RELATION_SW"/><field name="SW_ID"/><field name="COORDINATE"/><field name="OLD_ID"/><parameter name="deptName" type="String" default-value=""/><parameter name="title" type="String" default-value=""/></dataset><dataset name="time" type="sql"><sql><![CDATA[select * from cat_check]]></sql><field name="ID"/><field name="AJ_ID"/><field name="ACCEPT_DATE"/><field name="CHECK_DATE"/><field name="TIME"/><field name="create_user_id"/><field name="create_user_name"/><field name="create_time"/><field name="modify_time"/><field name="create_dept_id"/><field name="create_dept_name"/></dataset></datasource><paper type="A4" left-margin="90" right-margin="90"
    top-margin="72" bottom-margin="72" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="landscape" html-report-align="left" bg-image="" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/catCgxx_original_ureport.xml

New file
@@ -0,0 +1,3 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料类别]]></simple-value></cell><cell expand="None" name="B1" row="1" col="2" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料类别]]></simple-value></cell><cell expand="None" name="C1" row="1" col="3" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料类别]]></simple-value></cell><cell expand="None" name="D1" row="1" col="4" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[数量]]></simple-value></cell><cell expand="None" name="E1" row="1" col="5" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[数量]]></simple-value></cell><cell expand="Down" name="A3" row="3" col="1" left-cell="root" top-cell="root"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="keyword" aggregate="group" property="name1" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="B3" row="3" col="2"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="keyword" aggregate="group" property="name2" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="C3" row="3" col="3"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="keyword" aggregate="group" property="name3" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="D3" row="3" col="4"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="count" property="id" order="none" mapping-type="simple"><condition property="ZLLB" op="==" id="653999f0-b5d5-11ef-bdd2-7d0fb15468f5" type="property"><value><![CDATA[C3]]></value></condition></dataset-value></cell><cell expand="None" name="E3" row="3" col="5" left-cell="C3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="cgwjxx" aggregate="count" property="id" order="none" mapping-type="simple"><condition property="ZLLB" op="==" id="undefined" type="property"><value><![CDATA[C3]]></value></condition></dataset-value></cell><cell expand="None" name="A4" row="4" col="1" left-cell="A3" top-cell="root" col-span="3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bgcolor="92,184,92" bold="false" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[合计]]></simple-value></cell><cell expand="None" name="D4" row="4" col="4" left-cell="A3" top-cell="root"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bgcolor="92,184,92" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[sum(D3)]]></expression-value></cell><cell expand="None" name="E4" row="4" col="5" left-cell="A3" top-cell="root"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bgcolor="92,184,92" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[sum(E3)]]></expression-value></cell><row row-number="1" height="18" band="title"/><row row-number="2" height="19" band="title"/><row row-number="3" height="18"/><row row-number="4" height="19"/><column col-number="1" width="122"/><column col-number="2" width="80"/><column col-number="3" width="80"/><column col-number="4" width="74"/><column col-number="5" width="74"/><datasource name="内置数据源" type="buildin"><dataset name="keyword" type="sql"><sql><![CDATA[select  a.param_name as name3 ,b.param_name as name2 , c.param_name as name1 from sys_keyword_param a LEFT JOIN  sys_keyword_param b  ON a.parent_id = b.param_id  LEFT JOIN sys_keyword_param c ON (b.parent_id = c.param_id or a.parent_id = c.param_id )and c.parent_id = 0   where  a.keyword_id = 1823280954771296257 and a.parent_id !=0 ]]></sql><field name="name3"/><field name="name2"/><field name="name1"/></dataset><dataset name="cgwjxx" type="sql"><sql><![CDATA[select a.id,b.ZLLB from cat_item_cgwjxx a LEFT JOIN cat_file_ajjxx b ON a.aj_id = b.id]]></sql><field name="id"/><field name="ZLLB"/></dataset><dataset name="ajjxx" type="sql"><sql><![CDATA[SELECT id, ZLLB FROM  cat_file_ajjxx ]]></sql><field name="id"/><field name="ZLLB"/></dataset></datasource><paper type="A4" left-margin="90" right-margin="90"
    top-margin="72" bottom-margin="72" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="landscape" html-report-align="left" bg-image="" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/catCgxx_tj.ureport.xml

New file
@@ -0,0 +1,3 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料类别]]></simple-value></cell><cell expand="None" name="B1" row="1" col="2" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料类别]]></simple-value></cell><cell expand="None" name="C1" row="1" col="3" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料类别]]></simple-value></cell><cell expand="None" name="D1" row="1" col="4" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[档]]></simple-value></cell><cell expand="None" name="E1" row="1" col="5" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[件]]></simple-value></cell><cell expand="Down" name="A3" row="3" col="1" left-cell="root" top-cell="root"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="keyword" aggregate="group" property="name1" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="B3" row="3" col="2"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="keyword" aggregate="group" property="name2" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="C3" row="3" col="3"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="keyword" aggregate="group" property="name3" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="D3" row="3" col="4"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="count" property="id" order="none" mapping-type="simple"><condition property="ZLLB" op="==" id="1d15c960-b1ec-11ef-adaa-59914be76865" type="property"><value><![CDATA[C3]]></value></condition></dataset-value></cell><cell expand="None" name="E3" row="3" col="5" left-cell="C3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="cgwjxx" aggregate="count" property="id" order="none" mapping-type="simple"><condition property="ZLLB" op="==" id="8480e520-b1ed-11ef-adaa-59914be76865" type="undefined"><value><![CDATA[C3]]></value></condition></dataset-value></cell><cell expand="None" name="A4" row="4" col="1" left-cell="A3" top-cell="root" col-span="3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bgcolor="92,184,92" bold="false" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[合计]]></simple-value></cell><cell expand="None" name="D4" row="4" col="4" left-cell="A3" top-cell="root"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bgcolor="92,184,92" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[sum(D3)]]></expression-value></cell><cell expand="None" name="E4" row="4" col="5" left-cell="A3" top-cell="root"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bgcolor="92,184,92" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[sum(E3)]]></expression-value></cell><row row-number="1" height="18" band="title"/><row row-number="2" height="19" band="title"/><row row-number="3" height="18"/><row row-number="4" height="19"/><column col-number="1" width="122"/><column col-number="2" width="80"/><column col-number="3" width="80"/><column col-number="4" width="74"/><column col-number="5" width="74"/><datasource name="内置数据源" type="buildin"><dataset name="keyword" type="sql"><sql><![CDATA[select  a.param_name as name3 ,b.param_name as name2 , c.param_name as name1 from sys_keyword_param a LEFT JOIN  sys_keyword_param b  ON a.parent_id = b.param_id  LEFT JOIN sys_keyword_param c ON (b.parent_id = c.param_id or a.parent_id = c.param_id )and c.parent_id = 0   where  a.keyword_id = 1823280954771296257 and a.parent_id !=0 ]]></sql><field name="name3"/><field name="name2"/><field name="name1"/></dataset><dataset name="cgwjxx" type="sql"><sql><![CDATA[select a.id,b.id as aj_id,b.ZLLB from cat_item_cgwjxx a LEFT JOIN cat_file_ajjxx b ON a.aj_id = b.id]]></sql><field name="id"/><field name="aj_id"/><field name="ZLLB"/></dataset><dataset name="ajjxx" type="sql"><sql><![CDATA[SELECT id, ZLLB FROM  cat_file_ajjxx ]]></sql><field name="id"/><field name="ZLLB"/></dataset></datasource><paper type="A4" left-margin="90" right-margin="90"
    top-margin="72" bottom-margin="72" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="landscape" html-report-align="center" bg-image="" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/processing_approval_hn.ureport.xml

New file
@@ -0,0 +1,20 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" col-span="13"><cell-style font-size="14" forecolor="0,0,0" font-family="宋体" bold="true" align="center" valign="middle"></cell-style><simple-value><![CDATA[湖南省自然资源厅机关档案加工单]]></simple-value></cell><cell expand="None" name="A2" row="2" col="1" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[申请日期：]]></simple-value></cell><cell expand="Down" name="C2" row="2" col="3" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" format="yyyy-MM-dd" align="left" valign="middle"></cell-style><dataset-value dataset-name="table3" aggregate="group" property="PROCESSING_DATE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="E2" row="2" col="5"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="F2" row="2" col="6"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="G2" row="2" col="7"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="H2" row="2" col="8"><cell-style font-size="9" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="I2" row="2" col="9" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="right" valign="middle"></cell-style><simple-value><![CDATA[编号：]]></simple-value></cell><cell expand="Down" name="K2" row="2" col="11" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><dataset-value dataset-name="table3" aggregate="group" property="APPLY_CODE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A3" row="3" col="1" row-span="5"><cell-style font-size="18" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[用

户

信

息]]></simple-value></cell><cell expand="None" name="B3" row="3" col="2" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[姓名]]></simple-value></cell><cell expand="None" name="D3" row="3" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="PROCESSING_USER_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G3" row="3" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[工作单位]]></simple-value></cell><cell expand="None" name="I3" row="3" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="DEPT_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="B4" row="4" col="2" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[联系方式]]></simple-value></cell><cell expand="None" name="D4" row="4" col="4"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[电话]]></simple-value></cell><cell expand="None" name="E4" row="4" col="5" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="TEL_NUMBER" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G4" row="4" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[手机]]></simple-value></cell><cell expand="None" name="I4" row="4" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="PROCESSING_TEL" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="B5" row="5" col="2" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[邮编]]></simple-value></cell><cell expand="None" name="D5" row="5" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="POST_CODE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G5" row="5" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[单位地址]]></simple-value></cell><cell expand="None" name="I5" row="5" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="DEPT_ADDRESS" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="B6" row="6" col="2" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[身份证号]]></simple-value></cell><cell expand="None" name="D6" row="6" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="ID_CARD" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="G6" row="6" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[涉密证号]]></simple-value></cell><cell expand="None" name="I6" row="6" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="CERTIFICATE_NUMBER" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="B7" row="7" col="2" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[利用目的]]></simple-value></cell><cell expand="None" name="D7" row="7" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table3" aggregate="group" property="PROCESSING_PURPOSE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A8" row="8" col="1" col-span="13"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[利用详情]]></simple-value></cell><cell expand="None" name="A9" row="9" col="1"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[序号]]></simple-value></cell><cell expand="None" name="B9" row="9" col="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[档号]]></simple-value></cell><cell expand="None" name="C9" row="9" col="3" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[件号]]></simple-value></cell><cell expand="None" name="E9" row="9" col="5" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[文件名]]></simple-value></cell><cell expand="None" name="H9" row="9" col="8"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[密级]]></simple-value></cell><cell expand="None" name="I9" row="9" col="9" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[涉密页码]]></simple-value></cell><cell expand="None" name="K9" row="9" col="11"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" wrap-compute="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[加工方式]]></simple-value></cell><cell expand="None" name="L9" row="9" col="12" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[数量]]></simple-value></cell><cell expand="None" name="A10" row="10" col="1" left-cell="C10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[row() - 9]]></expression-value></cell><cell expand="Down" name="B10" row="10" col="2" left-cell="C10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ARCHIVAL_CODE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="C10" row="10" col="3" left-cell="root" top-cell="root" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ITEM_NUMBER" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="E10" row="10" col="5" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="ITEM_TITLE" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="H10" row="10" col="8" left-cell="C10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="Down" name="I10" row="10" col="9" left-cell="C10" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="table2" aggregate="select" property="SECURITY_PAGE_NUM" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="K10" row="10" col="11" left-cell="C10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[电子]]></simple-value></cell><cell expand="None" name="L10" row="10" col="12" left-cell="C10" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[1]]></simple-value></cell><cell expand="None" name="A11" row="11" col="1" col-span="13"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[合计]]></simple-value></cell><cell expand="None" name="A12" row="12" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[电子文件复制总量：]]></simple-value></cell><cell expand="None" name="D12" row="12" col="4" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[346:MB,其中图文数字化：0份，数据量0.00MB,原始资料复制数量：0.00MB。]]></simple-value></cell><cell expand="None" name="A13" row="13" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[资料加工经办人]]></simple-value></cell><cell expand="None" name="D13" row="13" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[何峰]]></simple-value></cell><cell expand="None" name="G13" row="13" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[部门领导]]></simple-value></cell><cell expand="None" name="I13" row="13" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[孙立吉]]></simple-value></cell><cell expand="None" name="A14" row="14" col="1" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[服务窗口经办人]]></simple-value></cell><cell expand="None" name="D14" row="14" col="4" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[何峰]]></simple-value></cell><cell expand="None" name="G14" row="14" col="7" col-span="2"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[收款人]]></simple-value></cell><cell expand="None" name="I14" row="14" col="9" col-span="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="A15" row="15" col="1" row-span="5" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[申请人签名]]></simple-value></cell><cell expand="None" name="D15" row="15" col="4" row-span="3" col-span="10"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="left" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[  本人持有单位涉密证，系单位确认可借阅复制涉密涉密地质资料人员，将严格遵守“借阅复制涉密地质资料单位承诺”；妥善保管好地质资料。]]></simple-value></cell><cell expand="None" name="D18" row="18" col="4"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="E18" row="18" col="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="F18" row="18" col="6"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="G18" row="18" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="H18" row="18" col="8" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"></cell-style><simple-value><![CDATA[申请人：]]></simple-value></cell><cell expand="None" name="K18" row="18" col="11" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[年  月  日]]></simple-value></cell><cell expand="None" name="D19" row="19" col="4"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="E19" row="19" col="5"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="F19" row="19" col="6"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="G19" row="19" col="7"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="H19" row="19" col="8" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[领取人：]]></simple-value></cell><cell expand="None" name="K19" row="19" col="11" col-span="3"><cell-style font-size="11" forecolor="0,0,0" font-family="宋体" align="center" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[年  月  日]]></simple-value></cell><row row-number="1" height="26" band="title"/><row row-number="2" height="27" band="title"/><row row-number="3" height="27" band="title"/><row row-number="4" height="26" band="title"/><row row-number="5" height="26" band="title"/><row row-number="6" height="25" band="title"/><row row-number="7" height="29" band="title"/><row row-number="8" height="26" band="title"/><row row-number="9" height="26"/><row row-number="10" height="25"/><row row-number="11" height="27"/><row row-number="12" height="27" band="summary"/><row row-number="13" height="24" band="summary"/><row row-number="14" height="24" band="summary"/><row row-number="15" height="22" band="summary"/><row row-number="16" height="20" band="summary"/><row row-number="17" height="19" band="summary"/><row row-number="18" height="15" band="summary"/><row row-number="19" height="16" band="summary"/><column col-number="1" width="34"/><column col-number="2" width="47"/><column col-number="3" width="38"/><column col-number="4" width="40"/><column col-number="5" width="64"/><column col-number="6" width="38"/><column col-number="7" width="50"/><column col-number="8" width="44"/><column col-number="9" width="44"/><column col-number="10" width="43"/><column col-number="11" width="45"/><column col-number="12" width="25"/><column col-number="13" width="28"/><footer  font-family="宋体" font-size="10" forecolor="0,0,0" margin="23"><center><![CDATA["第"+page()+"页,共"+pages()+"页"]]></center></footer><datasource name="内置数据源" type="buildin"><dataset name="table2" type="sql"><sql><![CDATA[SELECT
    ARCHIVAL_CODE,
    FILE_TITLE,
    ITEM_TITLE,
    ITEM_NUMBER,
    SECURITY_PAGE_NUM,
    DEPT_NAME，
    case when DOWNLOAD = '1' and AGREE = '1' then '√'
    else '' end as DOWNLOAD,
    case when PRINT = '1' and AGREE = '1' then '√'
    else '' end as PRINT
    FROM UTL_PROCESSING_DETAIL WHERE FORM_ID = (:formId)]]></sql><field name="ARCHIVAL_CODE"/><field name="FILE_TITLE"/><field name="ITEM_TITLE"/><field name="ITEM_NUMBER"/><field name="SECURITY_PAGE_NUM"/><field name="DEPT_NAME"/><field name="DOWNLOAD"/><field name="PRINT"/><parameter name="formId" type="String" default-value="-1"/></dataset><dataset name="table3" type="sql"><sql><![CDATA[select * from UTL_PROCESSING_FORM where FORM_ID =(:formId)]]></sql><field name="FORM_ID"/><field name="APPLY_CODE"/><field name="PROCESSING_TYPE"/><field name="PROCESSING_USER_ID"/><field name="PROCESSING_USER_NAME"/><field name="POST_CODE"/><field name="CERTIFICATE_NUMBER"/><field name="TEL_NUMBER"/><field name="PROCESSING_TEL"/><field name="PROCESSING_DATE"/><field name="PROCESSING_VALID_DATE"/><field name="PROCESSING_PURPOSE"/><field name="REMARK"/><field name="STATE"/><field name="SECURITY_CLASSIFICATION"/><field name="DEPT_NAME"/><field name="DEPT_ADDRESS"/><field name="PROJECT_TYPE"/><field name="PROJECT_NAME"/><field name="CREATE_USER_ID"/><field name="CREATE_USER_NAME"/><field name="CREATE_TIME"/><field name="MODIFY_TIME"/><field name="CREATE_DEPT_ID"/><field name="CREATE_DEPT_NAME"/><field name="SECURITY_CODE"/><field name="DELETE_STATE"/><field name="DELETE_TIME"/><field name="FULLTEXT_STATE"/><field name="FLOW_STATE"/><field name="PROCESS_INSTANCE_ID"/><field name="FLOW_STEP"/><field name="FILE_COUNT"/><field name="ITEM_COUNT"/><field name="ID_CARD"/><field name="OTHER_APPLY"/><parameter name="formId" type="String" default-value="-1"/></dataset></datasource><paper type="A4" left-margin="28" right-margin="28"
    top-margin="57" bottom-margin="43" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="portrait" html-report-align="center" bg-image="" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/test.ureport.xml

New file
@@ -0,0 +1,3 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[序号]]></simple-value></cell><cell expand="None" name="B1" row="1" col="2" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[报告名称]]></simple-value></cell><cell expand="None" name="C1" row="1" col="3" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[报告编制单位]]></simple-value></cell><cell expand="None" name="D1" row="1" col="4" row-span="2"><cell-style font-size="10" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[联系姓名]]></simple-value></cell><cell expand="None" name="E1" row="1" col="5" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[联系电话]]></simple-value></cell><cell expand="None" name="F1" row="1" col="6" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[第一次（新接收）]]></simple-value></cell><cell expand="None" name="H1" row="1" col="8" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[第二次]]></simple-value></cell><cell expand="None" name="J1" row="1" col="10" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[第三次]]></simple-value></cell><cell expand="None" name="L1" row="1" col="12" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[第四次]]></simple-value></cell><cell expand="None" name="N1" row="1" col="14" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[第五次]]></simple-value></cell><cell expand="None" name="P1" row="1" col="16" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[馆内验收人]]></simple-value></cell><cell expand="None" name="Q1" row="1" col="17" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[总修改次数]]></simple-value></cell><cell expand="None" name="R1" row="1" col="18" row-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[总体验收情况]]></simple-value></cell><cell expand="None" name="F2" row="2" col="6"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[接收时间]]></simple-value></cell><cell expand="None" name="G2" row="2" col="7"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[验收时间]]></simple-value></cell><cell expand="None" name="H2" row="2" col="8"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[接收时间]]></simple-value></cell><cell expand="None" name="I2" row="2" col="9"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[验收时间]]></simple-value></cell><cell expand="None" name="J2" row="2" col="10"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[接收时间]]></simple-value></cell><cell expand="None" name="K2" row="2" col="11"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[验收时间]]></simple-value></cell><cell expand="None" name="L2" row="2" col="12"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[接收时间]]></simple-value></cell><cell expand="None" name="M2" row="2" col="13"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[验收时间]]></simple-value></cell><cell expand="None" name="N2" row="2" col="14"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[接收时间]]></simple-value></cell><cell expand="None" name="O2" row="2" col="15"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[验收时间]]></simple-value></cell><cell expand="Down" name="A3" row="3" col="1" left-cell="B3"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><expression-value><![CDATA[return row() - 2]]></expression-value></cell><cell expand="Down" name="B3" row="3" col="2" left-cell="root" top-cell="root"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="ZLMC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="C3" row="3" col="3"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="XCDWMC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="D3" row="3" col="4"><cell-style font-size="10" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="HJRMC" order="none" mapping-type="simple"></dataset-value></cell><cell expand="Down" name="E3" row="3" col="5"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="HJRLXFS" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="F3" row="3" col="6" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="ACCEPT_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="undefined" type="property" join="and"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="undefined" type="property" join="and"><value><![CDATA[1]]></value></condition></dataset-value><condition-property-item name="ss"><cell-style for-condition="true" font-size-scope="cell" forecolor-scope="cell" font-family-scope="cell" bgcolor-scope="cell" bold-scope="cell" italic-scope="cell" underline-scope="cell" align-scope="cell" valign-scope="cell"></cell-style></condition-property-item></cell><cell expand="None" name="G3" row="3" col="7" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="CHECK_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="undefined" type="property" join="and"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="undefined" type="property" join="and"><value><![CDATA[1]]></value></condition></dataset-value></cell><cell expand="None" name="H3" row="3" col="8" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="ACCEPT_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="undefined" type="property" join="and"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="undefined" type="property" join="and"><value><![CDATA[2]]></value></condition></dataset-value></cell><cell expand="None" name="I3" row="3" col="9" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" format="yyyy-MM-dd" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="select" property="CHECK_DATE" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="undefined" type="property" join="and"><value><![CDATA[ajjxx.select(id)]]></value></condition><condition property="TIME" op="==" id="undefined" type="property" join="and"><value><![CDATA[2]]></value></condition></dataset-value></cell><cell expand="None" name="J3" row="3" col="10"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="K3" row="3" col="11"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="L3" row="3" col="12"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="M3" row="3" col="13"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="N3" row="3" col="14"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="None" name="O3" row="3" col="15"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><cell expand="Down" name="P3" row="3" col="16" left-cell="B3"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="ajjxx" aggregate="select" property="YSR" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="Q3" row="3" col="17"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="time" aggregate="max" property="TIME" order="none" mapping-type="simple"><condition property="AJ_ID" op="==" id="undefined" type="property"><value><![CDATA[ajjxx.select(id)]]></value></condition></dataset-value></cell><cell expand="None" name="R3" row="3" col="18"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="center" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[]]></simple-value></cell><row row-number="1" height="18" band="title"/><row row-number="2" height="19" band="title"/><row row-number="3" height="18"/><column col-number="1" width="35"/><column col-number="2" width="122"/><column col-number="3" width="80"/><column col-number="4" width="80"/><column col-number="5" width="74"/><column col-number="6" width="70"/><column col-number="7" width="63"/><column col-number="8" width="58"/><column col-number="9" width="60"/><column col-number="10" width="65"/><column col-number="11" width="66"/><column col-number="12" width="74"/><column col-number="13" width="74"/><column col-number="14" width="74"/><column col-number="15" width="74"/><column col-number="16" width="74"/><column col-number="17" width="74"/><column col-number="18" width="74"/><datasource name="内置数据源" type="buildin"><dataset name="ajjxx" type="sql"><sql><![CDATA[select * from cat_file_ajjxx]]></sql><field name="ID"/><field name="ZLLY"/><field name="HJRDH"/><field name="SGDH"/><field name="DH"/><field name="BZSDH"/><field name="HJZSDW"/><field name="BSSJ"/><field name="ZSDWAJH"/><field name="JSRQ"/><field name="JSDWMC"/><field name="BGDWMC"/><field name="ZLMC"/><field name="FZMC"/><field name="BZZ"/><field name="ZLLB"/><field name="ZLLBDM"/><field name="YZ"/><field name="GZCD"/><field name="QTGZCD"/><field name="GZFF"/><field name="SPSJ"/><field name="SMQK"/><field name="MJ"/><field name="SFBH"/><field name="BHQ"/><field name="BHSX"/><field name="HJPZH"/><field name="FZRQ"/><field name="FBRQ"/><field name="GJZ"/><field name="NRZY"/><field name="BGQX"/><field name="BZ"/><field name="HJRMC"/><field name="HJRDZ"/><field name="HJRTYSHXYDM"/><field name="HJRYB"/><field name="HJRLXR"/><field name="HJRLXFS"/><field name="HJRDZYX"/><field name="QSJD_FX"/><field name="QSJD_DU"/><field name="QSJD_FEN"/><field name="QSJD_MIAO"/><field name="ZZJD_FX"/><field name="ZZJD_DU"/><field name="ZZJD_FEN"/><field name="ZZJD_MIAO"/><field name="QSWD_FX"/><field name="QSWD_DU"/><field name="QSWD_FEN"/><field name="QSWD_MIAO"/><field name="ZZWD_FX"/><field name="ZZWD_DU"/><field name="ZZWD_FEN"/><field name="ZZWD_MIAO"/><field name="GDZB"/><field name="DLZBX"/><field name="XZQMC"/><field name="XZQDM"/><field name="KCDM"/><field name="KCMC"/><field name="DDGZWZ"/><field name="CKD"/><field name="ZYKZ"/><field name="CKSD"/><field name="CYLX"/><field name="ZYCGJS"/><field name="YDZWJGSJBB"/><field name="YJHJ"/><field name="RJHJ"/><field name="TJXTKZKTYSM"/><field name="QTSM"/><field name="ZWZZJS"/><field name="SPZZJS"/><field name="FTZZJS"/><field name="FBZZJS"/><field name="FJZZJS"/><field name="QTZJS"/><field name="HDS"/><field name="ZWDZJS"/><field name="SPDZJS"/><field name="FTDZJS"/><field name="FBDZJS"/><field name="FJDZJS"/><field name="RJDZJS"/><field name="SJKDZJS"/><field name="DMTDZJS"/><field name="QTDZJS"/><field name="CGZLSJL"/><field name="CGZLDZWJZS"/><field name="CGZLDZJS"/><field name="CGZLZZJS"/><field name="CGZLDZWJJZS"/><field name="DZZJS"/><field name="CZZJS"/><field name="GZZJS"/><field name="TZZJS"/><field name="YZZJS"/><field name="SZZJS"/><field name="LZZJS"/><field name="XZZJS"/><field name="ZZZJS"/><field name="WZZJS"/><field name="DDZJS"/><field name="CDZJS"/><field name="GDZJS"/><field name="TDZJS"/><field name="YDZJS"/><field name="SDZJS"/><field name="LDZJS"/><field name="XDZJS"/><field name="ZDZJS"/><field name="WDZJS"/><field name="YSDZSJL"/><field name="SWDH"/><field name="SWZLLB"/><field name="SWZLBCDW"/><field name="ZKSL"/><field name="ZJC"/><field name="YXZSL"/><field name="YXIZSL"/><field name="BBZSL"/><field name="YPZSL"/><field name="GPZSL"/><field name="BPZSL"/><field name="QTSWMC"/><field name="SWBZ"/><field name="QTSWSL"/><field name="XMKYQXZ"/><field name="XMKYQLX"/><field name="XMKYQMC"/><field name="XMKYQBH"/><field name="QSSJ"/><field name="ZZSJ"/><field name="XMZGJGMC"/><field name="XMCDDWKYQR"/><field name="XMFZR"/><field name="ZJLY"/><field name="XMXXSM"/><field name="XCDWMC"/><field name="XZDWDZ"/><field name="XZDWYB"/><field name="XZDWXYDM"/><field name="XZDWYX"/><field name="XZDWLXR"/><field name="XZDWLXRDH"/><field name="YSJZSJ"/><field name="SLR"/><field name="SLSJ"/><field name="CJSJ"/><field name="ZLZT"/><field name="ZLUZT"/><field name="FBZT"/><field name="YSR"/><field name="YSWSJ"/><field name="PZXXLRZT"/><field name="FBFSJ"/><field name="FBR"/><field name="ZWYDZJS"/><field name="SPYDZJS"/><field name="FTYDZJS"/><field name="FBYDZJS"/><field name="FJYDZJS"/><field name="RJYDZJS"/><field name="SJKYDZJS"/><field name="DMTYDZJS"/><field name="QTYDZJS"/><field name="ZWCDDZJS"/><field name="SPCDDZJS"/><field name="FTCDDZJS"/><field name="FBCDDZJS"/><field name="FJCDDZJS"/><field name="RJCDDZJS"/><field name="SJKCDDZJS"/><field name="DMTCDDZJS"/><field name="QTCDDZJS"/><field name="QTZZJS"/><field name="YSZLDZJS"/><field name="YSZLSJL"/><field name="YSZLDZWJZS"/><field name="YSZLDZWJJZS"/><field name="YSZLZZJS"/><field name="create_dept_name"/><field name="create_dept_id"/><field name="modify_time"/><field name="create_time"/><field name="create_user_name"/><field name="create_user_id"/><field name="delete_state"/><field name="fulltext_state"/><field name="XCSJ"/><field name="SPJG"/><field name="XCDWSHXYDM"/><field name="DLWZS"/></dataset><dataset name="time" type="sql"><sql><![CDATA[select * from cat_check]]></sql><field name="ID"/><field name="AJ_ID"/><field name="ACCEPT_DATE"/><field name="CHECK_DATE"/><field name="TIME"/><field name="create_user_id"/><field name="create_user_name"/><field name="create_time"/><field name="modify_time"/><field name="create_dept_id"/><field name="create_dept_name"/></dataset></datasource><paper type="A4" left-margin="90" right-margin="90"
    top-margin="72" bottom-margin="72" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="landscape" html-report-align="left" bg-image="" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/ureportfiles/utilization_user_ureport.xml

New file
@@ -0,0 +1,3 @@
<?xml version="1.0" encoding="UTF-8"?><ureport><cell expand="None" name="A1" row="1" col="1" col-span="2"><cell-style font-size="12" forecolor="0,0,0" font-family="微软雅黑" bold="true" align="center" valign="middle"></cell-style><simple-value><![CDATA[借阅系统登录信息条]]></simple-value></cell><cell expand="None" name="A2" row="2" col="1"><cell-style font-size="10" font-family="微软雅黑" align="left" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[ 登录名称：]]></simple-value></cell><cell expand="Down" name="B2" row="2" col="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><top-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="UserCheck" aggregate="group" property="LOGIN_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A3" row="3" col="1"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"><left-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[ 登录密码：]]></simple-value></cell><cell expand="Down" name="B3" row="3" col="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="UserCheck" aggregate="group" property="PASSWORD" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A4" row="4" col="1"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"><left-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[ 姓      名：]]></simple-value></cell><cell expand="Down" name="B4" row="4" col="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="UserCheck" aggregate="group" property="USER_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A5" row="5" col="1"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"><left-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[ 工作单位：]]></simple-value></cell><cell expand="Down" name="B5" row="5" col="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="UserCheck" aggregate="group" property="DEPT_NAME" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A6" row="6" col="1"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"><left-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[ 涉密权限：]]></simple-value></cell><cell expand="Down" name="B6" row="6" col="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="UserCheck" aggregate="group" property="SECURITY" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A7" row="7" col="1"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"><left-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><simple-value><![CDATA[ 有 效  期：]]></simple-value></cell><cell expand="Down" name="B7" row="7" col="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"><right-border width="1" style="solid" color="0,0,0"/><bottom-border width="1" style="solid" color="0,0,0"/></cell-style><dataset-value dataset-name="UserCheck" aggregate="group" property="data" order="none" mapping-type="simple"></dataset-value></cell><cell expand="None" name="A8" row="8" col="1" row-span="2" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="bottom"></cell-style><simple-value><![CDATA[ 借阅须知：]]></simple-value></cell><cell expand="None" name="A10" row="10" col="1" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"></cell-style><simple-value><![CDATA[1．请将随身携带的包、相机、手机、笔记本电脑等与借阅无关的物品寄放存包处。]]></simple-value></cell><cell expand="None" name="A11" row="11" col="1" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"></cell-style><simple-value><![CDATA[2．阅览室禁止拍照，禁止将纸质资料带出阅览室。]]></simple-value></cell><cell expand="None" name="A12" row="12" col="1" col-span="2"><cell-style font-size="10" forecolor="0,0,0" font-family="微软雅黑" align="left" valign="middle"></cell-style><simple-value><![CDATA[3．请注意自身仪表，勿着汗背心、穿拖鞋入馆，馆内严禁吸烟。]]></simple-value></cell><row row-number="1" height="20" band="title"/><row row-number="2" height="20"/><row row-number="3" height="20"/><row row-number="4" height="20"/><row row-number="5" height="20"/><row row-number="6" height="20"/><row row-number="7" height="20"/><row row-number="8" height="11"/><row row-number="9" height="8"/><row row-number="10" height="20"/><row row-number="11" height="20"/><row row-number="12" height="20"/><column col-number="1" width="56"/><column col-number="2" width="355"/><datasource name="内置数据源" type="buildin"><dataset name="UserCheck" type="sql"><sql><![CDATA[select a.LOGIN_NAME,a.USER_NAME,b.PASSWORD, a.DEPT_NAME,b.SECURITY,to_char(VALID_START, 'YYYY-MM-DD')||'至'||to_char(VALID_END, 'YYYY-MM-DD') as data from UTL_USER_CHECK a LEFT JOIN UTL_UTILIZATION_USER b on a.utilization_user_id = b.ID where  a.id =:id]]></sql><field name="LOGIN_NAME"/><field name="USER_NAME"/><field name="PASSWORD"/><field name="DEPT_NAME"/><field name="SECURITY"/><field name="DATA"/><parameter name="id" type="String" default-value="1135188211480395776"/></dataset></datasource><paper type="A4" left-margin="90" right-margin="90"
    top-margin="72" bottom-margin="72" paging-mode="fitpage" fixrows="0"
    width="595" height="842" orientation="portrait" html-report-align="center" bg-image="" html-interval-refresh-value="0" column-enabled="false"></paper></ureport>

 src/main/webapp/WEB-INF/view/gh/borrow/borrowForm.jsp

@@ -148,9 +148,6 @@
                                       style="width:310px"
                                       value="${borrowForm.deptAddress}"
                                       data-options="tipPosition:'bottom'"/>
                                <input type="hidden" id="utilizationMethod" name="utilizationMethod" type="text"
                                       style="width:310px" value="${borrowForm.utilizationMethod}"
                                       readonly/>
                            </td>
                        </tr>
                        <tr>
@@ -185,13 +182,19 @@
                                       value="${borrowForm.borrowTel}"
                                       data-options="tipPosition:'bottom'" readonly/>
                            </td>
                            <td class="tbtitle">涉密证书编号:</td>
<%--                            <td class="tbtitle">涉密证书编号:</td>--%>
<%--                            <td>--%>
<%--                                <input class="easyui-textbox" id="certificateNumber" name="certificateNumber"--%>
<%--                                       type="text"--%>
<%--                                       style="width:310px"--%>
<%--                                       value="${borrowForm.certificateNumber}"--%>
<%--                                       data-options="tipPosition:'bottom'" readonly/>--%>
<%--                            </td>--%>
                            <td class="tbtitle">是否通过流程:</td>
                            <td>
                                <input class="easyui-textbox" id="certificateNumber" name="certificateNumber"
                                       type="text"
                                       style="width:310px"
                                       value="${borrowForm.certificateNumber}"
                                       data-options="tipPosition:'bottom'" readonly/>
                                <input type="hidden" id="utilizationMethod" name="utilizationMethod" type="text"
                                       style="width:310px" value="${borrowForm.utilizationMethod}"
                                       readonly/>
                            </td>
                        </tr>
                        <tr>
@@ -352,7 +355,7 @@
                <button class="pt-btn pt-btn-primary" onclick="dealFlow()">流程办理</button>
            </c:if>
            <%--            <c:if test="${borrowForm.flowState==1}">--%>
            <%--                <button class="pt-btn pt-btn-warning" onclick="reportPrinting()"><i class="fa fa-map-o"></i>打印借阅单--%>
                            <button class="pt-btn pt-btn-warning" onclick="reportPrinting()"><i class="fa fa-map-o"></i>打印借阅单
            <%--                </button>--%>
            <%--            </c:if>--%>
            <button class="pt-btn pt-btn-default" onclick="closeWindow()">关闭</button>

 src/main/webapp/WEB-INF/view/gh/physical/physicalForm.jsp

@@ -373,10 +373,10 @@
            <c:if test="${task!=null || approvePermission}">
                <button class="pt-btn pt-btn-primary" onclick="dealFlow()">流程办理</button>
            </c:if>
            <c:if test="${physicalForm.flowState==1}">

                <button class="pt-btn pt-btn-warning" onclick="reportPrinting()"><i class="fa fa-map-o"></i>打印实物利用单
                </button>
            </c:if>

            <button class="pt-btn pt-btn-default" onclick="closeWindow()">关闭</button>
        </div>
    </div>
@@ -893,15 +893,10 @@

    //打印实物利用单
    function reportPrinting() {
        var flag = ${archivesUtilizationForm.utilizationType==1};
        // var reportFile = "borrow_approval.ureport.xml";
        var reportFile = "borrow_approval_hn.ureport.xml";
        if (flag) {
            // reportFile = "borrow_approval_sampling.ureport.xml";
            reportFile = "borrow_approval_hn.ureport.xml";
        }

        var reportFile = "borrow_approval_gh.ureport.xml";
        var path = "<%=path%>";
        var url = path + "/ureport/preview?_u=file:" + reportFile + "&_i=1&formId=" + '${archivesUtilizationForm.formId}';
        var url = path + "/ureport/preview?_u=file:" + reportFile + "&_i=1&formId=" + '${physicalForm.formId}';
        window.open(url);
    }