Custom Report for Projects Module
Hi,
can please ask for a custom query report for the Project module?
Columns are to be as following:
Project Title
Project Status
Project Schedule Start
Project Actual Start
Project Schedule End
Project Actual End
Project Estimated Hours
Project Actual Hours
Project Estimated cost ($)
Project Actual Cost
SUM Hours in Worklogs on this Project (all Milestones and all Tasks in the Project)
Milestone Title
Milestone Status
Milestone Schedule Start
Milestone Actual Start
Milestone Schedule End
Milestone Actual End
Milestone Estimated Hours
Milestone Actual Hours
SUM of Hours in Worklogs on this Milestone (all Milestones and all Tasks in the Project)
Task Title
Task Status
Task Scheduled Start
Task Actual Start
Task Scheduled End
Task Actual End
Task % of Completion
Task Additional Cost ($)
Task Estimated Effort
SUM Hours in Worklogs on this Task
Ordering by the following:
Project Status (open,onhold,closed,canceled)
Project Title
Milestone Schedule Start
Task Scheduled Start
Please let me know if this is possible.
Cheers,
Per
Topic Participants
Per Lasse Baasch
ServiceDesk Plus
Tim Crosby
Larria
Cherubina H