SQL Server数据库+帆软报表
问题
同一施工队多条需要整改的数据需要在同一个字段内显示
即:一对多的多条数据要汇总到一条数据中
解决
参考之前,同一会议多人参加,按照会议把人分组,汇总显示会议参会人员
// 按会议分组代码
select c.Id,c.Title,c.host,c.meetdate,c.position,c.content,
( select ' '+hum_name from hyjl_zz b WHERE b.FK=c.Id for xml path('')
)
as names
from hyjl_z c
WHERE CAST(c.FK as varchar(36))='${Id}'
GROUP by c.Id ,c.Title,c.host,c.meetdate,c.position,c.content
修改代码,适用于这一次
// 按施工队分组代码
select c.Id,d.Id,d.sgdw,d.fzr+'施工队:' as fzra,d.zyhstatus,d.zgqx,d.zgqk,d.fzr+CAST(c.Id as varchar(36)) AS fyId,
( select ' '+b.zyhstatus from daypc_zz b WHERE b.FK=c.Id AND b.sgdw=d.sgdw for xml path('')
)
as statuses,
( select ' '+b.zgqk from daypc_zz b WHERE b.FK=c.Id AND b.sgdw=d.sgdw for xml path('')
)
as zgqks
from daypc_z c INNER JOIN daypc_zz d ON d.FK=c.Id
WHERE CAST(c.FK as varchar(36))='${Id}'
GROUP by c.Id,d.Id,d.sgdw,d.fzr,d.zyhstatus,d.zgqx,d.zgqk
新的分页id是同一条子表数据对应的几条孙表数据中施工队负责人相同的出现在同一页.