|
楼主 |
发表于 2017-8-10 15:58:52
|
显示全部楼层
再次感谢你的回答第一张图是我输出xml报表的代码
第二张图是我整理后的xml格式
第三张是报表显示的结果
ksql代码如下:
- select AS_ItemDetails,AS_ItemDetails.fID_id as fID_id,AS_OrganizationDepartement.fOD_name as fOD_name,AS_CostItems.fCI_name as fCI_name,AS_ItemDetails.fID_date as fID_date,AS_ItemDetails.fID_money as fID_money
- from AS_ItemDetails AS_ItemDetails
- join AS_OrganizationDepartement AS_OrganizationDepartement on AS_ItemDetails.fID_OD_id = AS_OrganizationDepartement.fOD_id
- join AS_CostItems AS_CostItems on AS_ItemDetails.fID_CI_id = AS_CostItems.fCI_id
复制代码 sql代码如下:
- select temp.fID_id,temp.fID_OD_id,temp.fID_CI_id,fID_date,fID_money from(select fID_id,(select fOD_name from as_organizationdepartement where as_organizationdepartement.fOD_id=fID_OD_id) as fID_OD_id,(select fCI_name from as_costitems where as_costitems.fCI_id=as_itemdetails.fID_CI_id) as fID_CI_id,fID_date,fID_money from as_itemdetails) temp
复制代码
|
|