知识库 >> 软件使用教程及资料 >> 配置和管理 >> 报表功能 >> 
[#228] 统计当月各个项目中创建和关闭的事务数量
【内容】

新增一个“单个查询”类型的报表,使用如下的代码

 

------

select p.ProjectID as [项目ID],p.ProjectCode as [项目编码],p.Name as [项目名称],cr.Count as [创建事务数],cl.Count as [关闭事务数]
FROM Pts_Projects p
left join (SELECT ProjectID, COUNT(1) as Count FROM Pts_Problems WHERE  datediff(mm,[CreateTime],getdate())=0 group by ProjectID) cr on p.ProjectID=cr.ProjectID
left join (SELECT ProjectID,COUNT(1) as Count FROM Pts_Problems WHERE IsClosed=1 AND datediff(mm,[CreateTime],getdate())=0 group by ProjectID) cl on p.ProjectID = cl.ProjectID
ORDER BY p.Name
------

【备注】