The Report "Tasks Completed by Team" only returns Tasks whose parent is Incident - How do I make the parent Service Request?
Select Task.AssignmentID, Task.Subject asTaskSubject, (Select p.displayname fromEmployee p where p.loginid=Task.Owner) as TaskOwner,
Task.OwnerTeam as TaskTeam, Task.Details, s.ServiceReqNumber, s.Subject, s.Status, s.OwnerTeam, s.Owner, s.CreatedDateTime, s.LastModDateTime, s.Source from Task,
ServiceReq s whereTask.ParentLink_Category = 'servicereq' and task.ParentLink_recId= s.RecId and task.Status = 'Completed'
and Task.OwnerTeam in (@UserTeam)
andTask.createddatetime >=(@st_date) and task.Createddatetime <=(@en_date)
**Note that each field that is in the report will need to be modified to reflect service request (by name and by query)**