主从报表，从表按时间类型字段排序问题

ouxh923 · 发表于 2017-8-10 10:04:50

问题情况，如下图：

问题说明：

红框范围内的审批意见为从表数据，目前在从表的select里面已加入了按审批时间升序排序，
且报表ksql查询语句也加入了升序排序，但页面显示却是乱序的，请教下该怎么处理才能正常排序呢？

jishuang · 发表于 2017-8-10 13:37:42

在java中table输出前，把table的内容输出看看
http://bbs.wex5.com/forum.php?mo ... 6&pid=165049439

ouxh923 · 发表于 2017-8-15 09:30:42

jishuang 发表于 2017-8-10 13:37
在java中table输出前，把table的内容输出看看
http://bbs.wex5.com/forum.php?mod=redirect&goto=findpost& ...

我这边审批意见的从表的数据源直接用的功能页面上的bizData，是已经排好序了，在功能页面上的list展示是正常的，使用到报表的作用是为了打印，只是加了个主从关了批注，但顺序就不正常了

jishuang · 发表于 2017-8-15 10:53:25

数据源设置了，把报表中select上的排序去掉

ouxh923 · 发表于 2017-8-15 17:29:21

jishuang 发表于 2017-8-15 10:53
数据源设置了，把报表中select上的排序去掉

去掉select上排序后试了下，还是不能正常排序

jishuang · 发表于 2017-8-15 17:35:47

参考2楼的把table的内容输出看看

ouxh923 · 发表于 2017-8-16 10:45:46

jishuang 发表于 2017-8-15 17:35
参考2楼的把table的内容输出看看

按二楼打出来的内容如下，看了下顺序还是正确的：
<rows>
<userdata name="model">/C10V01/M000_CoreCode/data</userdata>
<userdata name="id-column-name">ApprovalDetail</userdata>
<userdata name="id-column-type">String</userdata>
<userdata name="id-column-define">ApprovalDetail</userdata>
<userdata name="userdata">whereVersion</userdata>
<userdata name="relations">ApprovalDetail.fApprovalDeptID,ApprovalDetail.fApprovalDeptName,ApprovalDetail.fApprovalOgnFID,ApprovalDetail.fApprovalOgnFName,ApprovalDetail.fApprovalStatus,ApprovalDetail.fApprovalTime,ApprovalDetail.fApprovalType,ApprovalDetail.fApprovaler,ApprovalDetail.fApprovalerFID,ApprovalDetail.fApprovalerID,ApprovalDetail.fCreateDeptID,ApprovalDetail.fCreateDeptName,ApprovalDetail.fCreateOgnFID,ApprovalDetail.fCreateOgnFName,ApprovalDetail.fCreatePsnFID,ApprovalDetail.fCreatePsnID,ApprovalDetail.fCreatePsnName,ApprovalDetail.fCreateTime,ApprovalDetail.fDepAdvice,ApprovalDetail.fRelationID,ApprovalDetail.fYN02,ApprovalDetail.version</userdata>
<userdata name="relation-types">String,String,String,String,String,DateTime,String,String,String,String,String,String,String,String,String,String,String,DateTime,Text,String,Integer,Integer</userdata>
<userdata name="relation-alias">fApprovalDeptID,fApprovalDeptName,fApprovalOgnFID,fApprovalOgnFName,fApprovalStatus,fApprovalTime,fApprovalType,fApprovaler,fApprovalerFID,fApprovalerID,fCreateDeptID,fCreateDeptName,fCreateOgnFID,fCreateOgnFName,fCreatePsnFID,fCreatePsnID,fCreatePsnName,fCreateTime,fDepAdvice,fRelationID,fYN02,version</userdata>
<userdata name="sys.rowid">ApprovalDetail</userdata>
<row id="0464164034684DBFA96C87FDD3F6842D">
<userdata name="recordState" />
<cell><![CDATA[1C2pWGIrPbJ9I4VPQS4]]></cell>
<cell><![CDATA[高中德育处]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn]]></cell>
<cell><![CDATA[]]></cell>
<cell><![CDATA[审批通过]]></cell>
<cell><![CDATA[2017-08-07T17:44:23.000Z]]></cell>
<cell><![CDATA[审批：资产采购]]></cell>
<cell><![CDATA[罗惠权]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn/1C2pWGIrPbJ9I4VPQS4.dpt/3yaCve1uFpGsFdacF9x@1C2pWGIrPbJ9I4VPQS4.psm]]></cell>
<cell><![CDATA[3yaCve1uFpGsFdacF9x]]></cell>
<cell><![CDATA[1C2pWGIrPbJ9I4VPQS4]]></cell>
<cell><![CDATA[高中德育处]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn]]></cell>
<cell><![CDATA[]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn/1C2pWGIrPbJ9I4VPQS4.dpt/WvyOtEPvunMy8sKiSE7@1C2pWGIrPbJ9I4VPQS4.psm]]></cell>
<cell><![CDATA[WvyOtEPvunMy8sKiSE7]]></cell>
<cell><![CDATA[杨璐]]></cell>
<cell><![CDATA[2017-08-07T17:34:17.000Z]]></cell>
<cell><![CDATA[同意]]></cell>
<cell><![CDATA[E6A0A4A90A0A44E986407E7EAF087472]]></cell>
<cell><![CDATA[1]]></cell>
<cell />
</row>
<row id="E7E68D58A49B4B9387BFCBAA25AD65B4">
<userdata name="recordState" />
<cell><![CDATA[axzwQyiP5lRymuVxNq8]]></cell>
<cell><![CDATA[校区领导]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn]]></cell>
<cell><![CDATA[]]></cell>
<cell><![CDATA[不通过]]></cell>
<cell><![CDATA[2017-08-07T18:17:41.000Z]]></cell>
<cell><![CDATA[审批：资产采购]]></cell>
<cell><![CDATA[肖扬昆]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn/axzwQyiP5lRymuVxNq8.dpt/hjtLYVDkOSNohS6l8N8@axzwQyiP5lRymuVxNq8.psm]]></cell>
<cell><![CDATA[hjtLYVDkOSNohS6l8N8]]></cell>
<cell><![CDATA[1C2pWGIrPbJ9I4VPQS4]]></cell>
<cell><![CDATA[高中德育处]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn]]></cell>
<cell><![CDATA[]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn/1C2pWGIrPbJ9I4VPQS4.dpt/3yaCve1uFpGsFdacF9x@1C2pWGIrPbJ9I4VPQS4.psm]]></cell>
<cell><![CDATA[3yaCve1uFpGsFdacF9x]]></cell>
<cell><![CDATA[罗惠权]]></cell>
<cell><![CDATA[2017-08-07T17:44:23.000Z]]></cell>
<cell><![CDATA[驳回]]></cell>
<cell><![CDATA[E6A0A4A90A0A44E986407E7EAF087472]]></cell>
<cell><![CDATA[1]]></cell>
<cell />
</row>
<row id="2616C6433FE341ACA2BCD9C6E9264FD2">
<userdata name="recordState" />
<cell><![CDATA[axzwQyiP5lRymuVxNq8]]></cell>
<cell><![CDATA[校区领导]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn]]></cell>
<cell><![CDATA[]]></cell>
<cell><![CDATA[审批通过]]></cell>
<cell><![CDATA[2017-08-07T18:19:12.000Z]]></cell>
<cell><![CDATA[审批：资产采购]]></cell>
<cell><![CDATA[肖扬昆]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn/axzwQyiP5lRymuVxNq8.dpt/hjtLYVDkOSNohS6l8N8@axzwQyiP5lRymuVxNq8.psm]]></cell>
<cell><![CDATA[hjtLYVDkOSNohS6l8N8]]></cell>
<cell><![CDATA[1C2pWGIrPbJ9I4VPQS4]]></cell>
<cell><![CDATA[高中德育处]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn]]></cell>
<cell><![CDATA[]]></cell>
<cell><![CDATA[/5Ro5zjknG0eFeI0g24O.ogn/93btg8YLwdE3th2Fncs.ogn/1C2pWGIrPbJ9I4VPQS4.dpt/WvyOtEPvunMy8sKiSE7@1C2pWGIrPbJ9I4VPQS4.psm]]></cell>
<cell><![CDATA[WvyOtEPvunMy8sKiSE7]]></cell>
<cell><![CDATA[杨璐]]></cell>
<cell><![CDATA[2017-08-07T18:18:36.000Z]]></cell>
<cell><![CDATA[同意]]></cell>
<cell><![CDATA[E6A0A4A90A0A44E986407E7EAF087472]]></cell>
<cell><![CDATA[0]]></cell>
<cell />
</row>
</rows>

jishuang · 发表于 2017-8-16 11:18:13

那就应该没问题，把excel文件发一看看

		自动登录	找回密码
密码			注册

[结贴] 主从报表，从表按时间类型字段排序问题