Add Avg Summary to Query Report for % Complete of total Project
I know this works in "Custom Report" but I can't get it working in a Query report (which I needed due to the specific project reporting required). Here is my report as is:
SELECT projdet.TITLE AS "Project Title", taskdet.TITLE AS "Task", taskowner.FIRST_NAME AS "IT Staff", longtodate(taskdet.SCHEDULEDSTARTTIME) AS "Scheduled Start", longtodate(taskdet.SCHEDULEDENDTIME) AS "Scheduled End ", longtodate(taskdet.ACTUALSTARTTIME) AS "Actual Start", longtodate(taskdet.ACTUALENDTIME) AS "Actual End", tasktype.TASKTYPENAME AS "Task Type", taskstatus.STATUSNAME AS "Task Status", taskdet.PER_OF_COMPLETION AS "% Of Completion" FROM ProjectDetails projdet
LEFT OUTER JOIN TaskToProjects ON projdet.PROJECTID=tasktoprojects.PROJECTID
LEFT JOIN TaskDetails taskdet ON tasktoprojects.TASKID = taskdet.TASKID
LEFT JOIN SDUser taskownersdu ON taskdet.OWNERID=taskownersdu.USERID
LEFT JOIN AaaUser taskowner ON taskownersdu.USERID=taskowner.USER_ID
LEFT JOIN StatusDefinition taskstatus ON taskdet.STATUSID=taskstatus.STATUSID
LEFT JOIN TaskTypeDefinition tasktype ON taskdet.TASKTYPEID=tasktype.TASKTYPEID
LEFT JOIN TaskToProjects projtotaskdet ON taskdet.TASKID=projtotaskdet.TASKID
LEFT JOIN TaskToProjects miletotaskdet ON taskdet.TASKID=miletotaskdet.TASKID
LEFT JOIN MileStoneDetails taskmilestone ON miletotaskdet.MILESTONEID=taskmilestone.MILESTONEID
WHERE (projdet.TITLE IS NOT NULL) ORDER BY 1 NULLS FIRST, taskowner.FIRST_NAME NULLS FIRST
I just want to have a % Complete "total" for the project (it shows for each individual task under the project). A "summary" line before the next project line will be fine.