主要的代码
report.xml
<?xml version="1.0" encoding="UTF-8"?>
<applications xmlns="http://www.wabacus.com"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.wabacus.com ../xsd/wabacus.applications.xsd">
<page id="listpage1">
<report id="report1" title="员工基本信息列表" pagesize="20" scrollstyle="image" scrollheight="300px" width="1000px" dataexport="richexcel">
<display>
<col column="{sequence:1}" label="序号"/>
<col column="no" label="工号" clickorderby="true" valuestyleproperty="style='mso-number-format:\@'"/>
<col column="name" label="姓名" clickorderby="true"/>
<group label="基本信息">
<col column="sex" label="性别" clickorderby="true" filterwidth="120px" filter="true"/>
<col column="age" label="年龄" clickorderby="true" filter="true" filterwidth="120px"/>
<col column="birthday" label="出生日期" clickorderby="true"/>
</group>
<col column="deptname" label="所属部门" filter="true" filterwidth="120px"/>
</display>
<sql>
<value>
<![CDATA[SELECT no,name,sex,age,birthday,deptname FROM tbl_baseinfo A left join tbl_department B on A.deptno=B.deptno where {#condition#} order by no]]>
</value>
<condition name="txtno" label="工号">
<value>
<![CDATA[(no like '%#data#%' )]]>
</value>
</condition>
<condition name="txtname" label="姓名">
<value>
<![CDATA[(name like '%#data#%' )]]>
</value>
</condition>
<condition name="txtsex" label="性别">
<value>
<![CDATA[(sex =#data#)]]>
</value>
<inputbox type="selectbox">
<option value="" label="性别"/>
<option value="1" label="男"/>
<option value="0" label="女" />
</inputbox>
</condition>
</sql>
<format>
<value>
sex=sex==null?"1":sex.trim();
if(sex.equals("0")) sex="女";
else sex="男";
birthday=birthday==null?"":birthday.trim();
int idx=birthday.indexOf(" ");//判断是否有时间,有的话就去掉时间,只显示日期
if(idx>0) birthday=birthday.substring(0,idx);
</value>
</format>
</report>
</page>
</applications>