新增一个“单个查询”类型的报表,使用如下的代码
------
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
------