明细报表问题

jy2013

jishuang 发表于 2013-10-10 13:24
把主表和另一个从表的数据也输出发一下

<rows><userdata name="model">/AJCG/report/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,Integer,String,DateTime,Integer,String,String,String,String,String,DateTime,DateTime,String,DateTime,Decimal,String,String,String,String,Text,Text,String,String,String,Decimal,String,String,String,String,String,Integer,String,String,String,String,String,Text,String,String,String,String,Text,String,String,Text,String,String,Text,String,String,Text,String,String,Text,String,String,Text,String,String,Text,String,String</userdata><userdata name="relation-alias">fID,version,fNo,fBillDate,fStatus,fStatusName,fCGXMID,fCGXMName,fGYSID,fGYSName,fHTQSRQ,fHTZZRQ,fHTNo,fHTQDRQ,fHTAmt,fZFFS,fHTXZ,fNote,fZDR,fAttachment,fHTFile,fLXR,fLXRDH,fHTLXR,fJESX,fJSDWID,fJSDWMC,fQTGLF1,fQTGLF2,fQTGLF3,fHTDYFS,fBM,fBMMC,fBMFID,fBMFMC,fSFJZCG,fHTZY,fSFXZFSP,fBillDate1,fHTQSRQ1,fHTZZRQ1,CGZJYJ,CGZJSPR,CGZJSPSJ,CWYSYJ,CWYSSPR,CWYSSPSJ,CWJLYSSPYJ,CWJLYSSPR,CWJLYSSPSJ,CWZJHQYJ,CWZJHQSPR,CWZJHQSPSJ,FWZJHQYJ,FWZJHQSPR,FWZJHQSPSJ,FGLDSPYJ,FGLDSPR,FGLDSPSJ,ZJLSPYJ,ZJLSPR,ZJLSPSJ</userdata><row><userdata name="recordState"/><cell><![CDATA[BF68EE6023F44159BD1B980BAD42C07D]]></cell><cell><![CDATA[2]]></cell><cell><![CDATA[HTLZ-2013-0002]]></cell><cell><![CDATA[2013-08-28T00:00:00.000Z]]></cell><cell><![CDATA[20]]></cell><cell><![CDATA[审批完成]]></cell><cell><![CDATA[C7BF3C4F842E42D0AAE1D09AD3DBCF2F]]></cell><cell><![CDATA[一体化管理体系培训]]></cell><cell><![CDATA[AA4CD04F6FA64E4DBAD671497FA03E51]]></cell><cell><![CDATA[通用公正技术服务（中国）有限公司]]></cell><cell><![CDATA[2013-08-28T00:00:00.000Z]]></cell><cell><![CDATA[2013-11-25T00:00:00.000Z]]></cell><cell/><cell/><cell><![CDATA[18000.00]]></cell><cell><![CDATA[转账]]></cell><cell><![CDATA[一次性合同]]></cell><cell/><cell><![CDATA[宋立]]></cell><cell><![CDATA[[{"docID":"C5D2D0841B10000164F7191713271D0C","docName":"CGXM-2013-0004-合同审核稿.doc","size":"458240","fileID":"16-defaultDocNameSpace","docPath":"/defaultDocNameSpace/bb03c5d9-d4a5-4b1b-ad03-9a6358d4f820","time":"2013-08-28T17:56:47.696Z"}]]]></cell><cell/><cell><![CDATA[宋立]]></cell><cell><![CDATA[25050656]]></cell><cell/><cell><![CDATA[0.00]]></cell><cell><![CDATA[AA4CD04F6FA64E4DBAD671497FA03E51]]></cell><cell><![CDATA[通用公正技术服务（中国）有限公司]]></cell><cell/><cell/><cell/><cell><![CDATA[4]]></cell><cell><![CDATA[2EBD72D04F0B443A929F576C1960CCAB]]></cell><cell><![CDATA[采购及供方管理部]]></cell><cell><![CDATA[/ORG01.ogn/2EBD72D04F0B443A929F576C1960CCAB.dpt]]></cell><cell><![CDATA[/安吉物流公司/采购及供方管理部]]></cell><cell><![CDATA[是]]></cell><cell><![CDATA[技术质量部提出采购申请，为提升公司内部审核员的一体化管理体系能力和意识，同时进行一体化管理体系升级培训，邀请通用公正技术服务（中国）有限公司提供为期3天的培训，并提交了单一供应商说明。为此，签订本合同，总金额18,000元。]]></cell><cell><![CDATA[否]]></cell><cell><![CDATA[2013-08-28]]></cell><cell><![CDATA[2013-08-28]]></cell><cell><![CDATA[2013-11-25]]></cell><cell><![CDATA[同意]]></cell><cell><![CDATA[彭峰]]></cell><cell><![CDATA[2013-08-30 16:16]]></cell><cell/><cell><![CDATA[李梅]]></cell><cell><![CDATA[2013-09-05 10:51]]></cell><cell><![CDATA[同意。]]></cell><cell><![CDATA[王文雄]]></cell><cell><![CDATA[2013-09-06 10:00]]></cell><cell><![CDATA[同意]]></cell><cell><![CDATA[许澄]]></cell><cell><![CDATA[2013-09-09 14:30]]></cell><cell><![CDATA[同意]]></cell><cell><![CDATA[孙国建]]></cell><cell><![CDATA[2013-09-04 15:18]]></cell><cell><![CDATA[同意]]></cell><cell><![CDATA[莫金康]]></cell><cell><![CDATA[2013-09-10 12:09]]></cell><cell><![CDATA[同意]]></cell><cell><![CDATA[余德]]></cell><cell><![CDATA[2013-09-17 13:18]]></cell></row></rows>
<rows><userdata name="model">/AJCG/report/data</userdata><userdata name="userdata">whereVersion</userdata><userdata name="relations">EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS,EXPRESS</userdata><userdata name="relation-types">String,Integer,String,String,String,String,Integer,Decimal,Decimal,String,String</userdata><userdata name="relation-alias">fID,version,fMasterID,fCGXMDetailID,fCGCP,fUnit,fQty,fPrice,fAmt,fNote,fGGXH</userdata><row><userdata name="recordState"/><cell><![CDATA[437FAB151A5740E1ADEE498F02C7FBE5]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[4C99EB62E37A4B8EAA77E853FCEFA78B]]></cell><cell><![CDATA[DC3E9ED243154445891E8B3C0E9E2C7A]]></cell><cell><![CDATA[质量月宣传海报]]></cell><cell><![CDATA[套]]></cell><cell><![CDATA[100]]></cell><cell><![CDATA[250.00]]></cell><cell><![CDATA[25000.00]]></cell><cell/><cell/></row><row><userdata name="recordState"/><cell><![CDATA[45967FB0D3094A52993EFFD7F7202433]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[9B37B49834B14345AF4F4DCCE40E904F]]></cell><cell><![CDATA[DC3E9ED243154445891E8B3C0E9E2C7A]]></cell><cell><![CDATA[质量月宣传海报]]></cell><cell><![CDATA[套]]></cell><cell><![CDATA[100]]></cell><cell><![CDATA[250.00]]></cell><cell><![CDATA[25000.00]]></cell><cell/><cell/></row><row><userdata name="recordState"/><cell><![CDATA[7BF2B36EC5354C6DB02603EC0FAF0CDE]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[BF68EE6023F44159BD1B980BAD42C07D]]></cell><cell><![CDATA[F0B3052C770F4CCAABB5FF2097289229]]></cell><cell><![CDATA[一体化管理体系培训]]></cell><cell><![CDATA[个]]></cell><cell><![CDATA[1]]></cell><cell><![CDATA[18000.00]]></cell><cell><![CDATA[18000.00]]></cell><cell/><cell><![CDATA[1]]></cell></row><row><userdata name="recordState"/><cell><![CDATA[E644FE5ED4D94A8DBD56CFFAE7B55F49]]></cell><cell><![CDATA[0]]></cell><cell><![CDATA[544D9A67BEB84A2EA841520F75B2C408]]></cell><cell><![CDATA[DC3E9ED243154445891E8B3C0E9E2C7A]]></cell><cell><![CDATA[质量月宣传海报]]></cell><cell><![CDATA[套]]></cell><cell><![CDATA[100]]></cell><cell><![CDATA[250.00]]></cell><cell><![CDATA[25000.00]]></cell><cell/><cell/></row></rows>

jishuang

e2.select(e2.sExecutorDeptName,'sData1=p1.fID')
在action中就没查吧，action中查的是sData1,sContent,sExecutorPersonName,sActualFinishTime

jy2013

可以了，原来是我数据源里漏写了