Report for all time cards relating to a project

[pkhoan]

Hello,

I have a Project A that has Project Task1, Project Task 2, and Project Task 3. I then have time cards against these 3 project tasks.

I also have Project B (with no project tasks) and time cards against Project B.

How do I create 1 report to pull all the time cards for Project A and all time cards for Project B? I cannot group by Project Name nor Number as the project tasks will have Project A as its parent project while Project B has no parent.

Has anyone encountered this type of problem or have any suggestions?

Thanks so much!

Spring

[Michael Fry1]

We created a database view, then you can report on totals by Project:

[edavidso]

Hi,

I'm not sure this is an ideal solution, but we run a report to collect the raw data from the time card table and then run a pivot table to summarize time submitted at a consistent level across different types of records in Service Now.   It takes some manipulation in excel before running the pivots, but is manageable until we find a better solution.

However, if you're always looking for the total time at the project level, the project record should always hold the sum of all the time on the tasks in the Actual Effort field.   I believe we've been able to pull the data that way and it displays either the total time logged against the child project tasks or the total time hit against the project itself based on the project configuration.

Good luck!

Erin

[Maurie]

so I am assuming i can do the same thing for Enhancement and Demand since we have Enhancement Task and Demand Task in our system?

[gyedwab]

What are you doing in Excel to prepare for the pivot? What's the output that you're creating in Excel?