reports on several task list in projects

Sebastien_Beauval_(sglcadmin32_-_(deleted))

I have several task list in several livelink project. How to do a report to list all the task of a user / somes users which come from the different tasks lists ?

Find more posts tagged with

Comments

OSHA_ICT_team_member_1_(oshauser1_-_(deleted))

You can maybe modify the default Livereport called "Outstanding Tasks For [User]" ? (If you succeed, please share your livereport !!!

Victoria_Freihofer_(rgsinc01admin_-_(deleted))

You can report on multiple task lists quite easily following this example: Create a new LiveReport & insert this SQL code- select DTree.*, (KUAF.LastName || ', ' || KUAF.First Name) as kuafname, decode(DTree.status, 0, 'Pending', 1, 'In Process', 2, 'Issue', 3, 'On Hold') as mystatus from DTree, KUAF where (KUAF.ID=DTree.Assignedto) and DTree.Status IN(0, 1, 2, 3) and DTree.OwnerID IN('95717', '1449193,' '3003327', '4600831', '7732624', '7733817') and %1 order by DateDue Replace the numbers in the DTree.OwnerID IN section with your task list id numbers. Set the report format to LiveReportSet Param %1 to Filter PermissionsSet up Display columns like thisField Column Title mystatus Statuskuafname Assigned ToDateAssigned Date AssignedDateDue Date Due You should get a listing of all active, uncompleted tasks from your selected task lists. Completed tasks will not be included. Note: This SQL is written for Oracle, if you are using SQL Server you will need to re-write the "Decode" line as a CASE statement