分组数据的报表，在链接中如何传参？

mdjmc1

分组数据的报表，如何添加隐藏列进行传参。我试过添加隐藏列，但出现重复行，如何解决？

jishuang

我试过添加隐藏列，但出现重复行什么意思？截图看一下效果

mdjmc1

mdjmc1

还有，添加隐藏列是什么意思？是在excel中添加吗？

jishuang

把excel文件发一下，隐藏列就是运行时不显示出这列的内容

mdjmc1

mainActivity_crossReport.rar (1.66 KB, 下载次数: 217)

2013-12-11 09:45 上传

点击文件名下载附件

mdjmc1

这个是excel文件，隐藏列怎么加呢？

jishuang

报表对应的action返回table之前加上
System.out.println(new com.justep.system.transform.Table2Row().transform(table,null).asXML());
把控制台的输出发一下

mdjmc1

<rows><userdata name="model">/taskManage/task/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,String,String,String,String,Integer,Integer</userdata><userdata name="relation-alias">fProjectName,fProjectID,fCreatePer,fCreatePerID,fMonth,fMonthNum,fWorkHours</userdata><row><userdata name="recordState"/><cell><![CDATA[测试系统项目001]]></cell><cell><![CDATA[08D0ABE31CBA40E1B4E04FC3641C2D3C]]></cell><cell><![CDATA[王惠媛]]></cell><cell><![CDATA[DBEE9756B36140FEBEED950D945B0229]]></cell><cell><![CDATA[11月]]></cell><cell><![CDATA[11]]></cell><cell><![CDATA[10]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[土勘院项目]]></cell><cell><![CDATA[266F94BB01C04427A2E6C8B984DA932F]]></cell><cell><![CDATA[能纪平]]></cell><cell><![CDATA[35DED97F382D470BAB4276AE4DFC9E36]]></cell><cell><![CDATA[12月]]></cell><cell><![CDATA[12]]></cell><cell><![CDATA[4]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[测试系统项目001]]></cell><cell><![CDATA[08D0ABE31CBA40E1B4E04FC3641C2D3C]]></cell><cell><![CDATA[王惠媛]]></cell><cell><![CDATA[DBEE9756B36140FEBEED950D945B0229]]></cell><cell><![CDATA[12月]]></cell><cell><![CDATA[12]]></cell><cell><![CDATA[1]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[测试系统项目001]]></cell><cell><![CDATA[08D0ABE31CBA40E1B4E04FC3641C2D3C]]></cell><cell><![CDATA[王惠媛]]></cell><cell><![CDATA[DBEE9756B36140FEBEED950D945B0229]]></cell><cell><![CDATA[12月]]></cell><cell><![CDATA[12]]></cell><cell><![CDATA[7]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[测试系统项目001]]></cell><cell><![CDATA[08D0ABE31CBA40E1B4E04FC3641C2D3C]]></cell><cell><![CDATA[王惠媛]]></cell><cell><![CDATA[DBEE9756B36140FEBEED950D945B0229]]></cell><cell><![CDATA[12月]]></cell><cell><![CDATA[12]]></cell><cell><![CDATA[1]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[土勘院项目]]></cell><cell><![CDATA[266F94BB01C04427A2E6C8B984DA932F]]></cell><cell><![CDATA[能纪平]]></cell><cell><![CDATA[35DED97F382D470BAB4276AE4DFC9E36]]></cell><cell><![CDATA[12月]]></cell><cell><![CDATA[12]]></cell><cell><![CDATA[8]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[测试系统项目001]]></cell><cell><![CDATA[08D0ABE31CBA40E1B4E04FC3641C2D3C]]></cell><cell><![CDATA[王惠媛]]></cell><cell><![CDATA[DBEE9756B36140FEBEED950D945B0229]]></cell><cell><![CDATA[12月]]></cell><cell><![CDATA[12]]></cell><cell><![CDATA[4]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[土勘院项目]]></cell><cell><![CDATA[266F94BB01C04427A2E6C8B984DA932F]]></cell><cell><![CDATA[能纪平]]></cell><cell><![CDATA[35DED97F382D470BAB4276AE4DFC9E36]]></cell><cell><![CDATA[12月]]></cell><cell><![CDATA[12]]></cell><cell><![CDATA[8]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[土勘院项目]]></cell><cell><![CDATA[266F94BB01C04427A2E6C8B984DA932F]]></cell><cell><![CDATA[能纪平]]></cell><cell><![CDATA[35DED97F382D470BAB4276AE4DFC9E36]]></cell><cell><![CDATA[12月]]></cell><cell><![CDATA[12]]></cell><cell><![CDATA[8]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[测试系统项目001]]></cell><cell><![CDATA[08D0ABE31CBA40E1B4E04FC3641C2D3C]]></cell><cell><![CDATA[王惠媛]]></cell><cell><![CDATA[DBEE9756B36140FEBEED950D945B0229]]></cell><cell><![CDATA[12月]]></cell><cell><![CDATA[12]]></cell><cell><![CDATA[8]]></cell></row><row><userdata name="recordState">new</userdata><cell changed="1"><![CDATA[测试系统项目001]]></cell><cell changed="1"/><cell changed="1"><![CDATA[王惠媛]]></cell><cell changed="1"/><cell changed="1"><![CDATA[01月]]></cell><cell changed="1"><![CDATA[1]]></cell><cell changed="1"/></row><row><userdata name="recordState">new</userdata><cell changed="1"><![CDATA[测试系统项目001]]></cell><cell changed="1"/><cell changed="1"><![CDATA[王惠媛]]></cell><cell changed="1"/><cell changed="1"><![CDATA[02月]]></cell><cell changed="1"><![CDATA[2]]></cell><cell changed="1"/></row><row><userdata name="recordState">new</userdata><cell changed="1"><![CDATA[测试系统项目001]]></cell><cell changed="1"/><cell changed="1"><![CDATA[王惠媛]]></cell><cell changed="1"/><cell changed="1"><![CDATA[03月]]></cell><cell changed="1"><![CDATA[3]]></cell><cell changed="1"/></row><row><userdata name="recordState">new</userdata><cell changed="1"><![CDATA[测试系统项目001]]></cell><cell changed="1"/><cell changed="1"><![CDATA[王惠媛]]></cell><cell changed="1"/><cell changed="1"><![CDATA[04月]]></cell><cell changed="1"><![CDATA[4]]></cell><cell changed="1"/></row><row><userdata name="recordState">new</userdata><cell changed="1"><![CDATA[测试系统项目001]]></cell><cell changed="1"/><cell changed="1"><![CDATA[王惠媛]]></cell><cell changed="1"/><cell changed="1"><![CDATA[05月]]></cell><cell changed="1"><![CDATA[5]]></cell><cell changed="1"/></row><row><userdata name="recordState">new</userdata><cell changed="1"><![CDATA[测试系统项目001]]></cell><cell changed="1"/><cell changed="1"><![CDATA[王惠媛]]></cell><cell changed="1"/><cell changed="1"><![CDATA[06月]]></cell><cell changed="1"><![CDATA[6]]></cell><cell changed="1"/></row><row><userdata name="recordState">new</userdata><cell changed="1"><![CDATA[测试系统项目001]]></cell><cell changed="1"/><cell changed="1"><![CDATA[王惠媛]]></cell><cell changed="1"/><cell changed="1"><![CDATA[07月]]></cell><cell changed="1"><![CDATA[7]]></cell><cell changed="1"/></row><row><userdata name="recordState">new</userdata><cell changed="1"><![CDATA[测试系统项目001]]></cell><cell changed="1"/><cell changed="1"><![CDATA[王惠媛]]></cell><cell changed="1"/><cell changed="1"><![CDATA[08月]]></cell><cell changed="1"><![CDATA[8]]></cell><cell changed="1"/></row><row><userdata name="recordState">new</userdata><cell changed="1"><![CDATA[测试系统项目001]]></cell><cell changed="1"/><cell changed="1"><![CDATA[王惠媛]]></cell><cell changed="1"/><cell changed="1"><![CDATA[09月]]></cell><cell changed="1"><![CDATA[9]]></cell><cell changed="1"/></row><row><userdata name="recordState">new</userdata><cell changed="1"><![CDATA[测试系统项目001]]></cell><cell changed="1"/><cell changed="1"><![CDATA[王惠媛]]></cell><cell changed="1"/><cell changed="1"><![CDATA[10月]]></cell><cell changed="1"><![CDATA[10]]></cell><cell changed="1"/></row></rows>

jishuang

你的这个报表有问题把，按月分组之后，fWorkHours还是有多个值的你怎么显示，你要的应该是还要按fWorkHours横向分组，然后显示的是最后一个值吧