创建一个“多个查询”类型的报表,报表定义中增加一个查询条件。
标题为“超时未关闭的事务”,结果类型为“表”,查询语句为:
SELECT ProjectName as [项目],ProblemCode as [编码],Title as [标题],'<a href=../pts/viewproblem.aspx?problem=' + cast(ProblemID as nvarchar(20)) + ' target=_blank>链接</a>' as [链接] FROM v_Pts_Problems WHERE IsClosed=0 AND AssignedTo IN (SELECT UserID FROM Accounts_Users WHERE DisplayName='@用户姓名') AND Deadline is not null AND Deadline < GetDate()
运行时参数增加:@用户姓名,要求必填。