报表类型:单个查询
报表SQL:
select p.ProjectID as [项目ID], (N'<a href="../pts/issuelist.aspx?project=' + cast(p.ProjectID as NVARCHAR(20)) + '&FilterType=1&procName=State_1&title=%e6%89%80%e6%9c%89%e6%89%93%e5%bc%80" target=_blank>' + p.Name + '</a>') as [项目名称],
odr.LastTime as [最后更新] FROM
(select ProjectID,MAX(LastTime) LastTime FROM Pts_Problems group by projectid
) odr
join v_Pts_Projects p on odr.ProjectID = p.ProjectID
order by odr.LastTime desc