Hours Collection on Project Report

[lauram26269131]

Hi, I'm creating a project report that I was hoping to use collections to pull information. I'm looking to pull hours by a specific job role from each project into a view. Ideally, it would be nice to have total up and not just list each entry. I've been trying for a while, but can't figure out how to get this to work. I can't even seem to be able to pull anything from hours into my project report. Looking at the API it would seem that a project report can do an hours collection. I'm stumped now and just feeling maybe it's not possible. Laura Manley Stream Companies

[DavidCo3]

Hi Laura, I can get you part way there. Someone else may swoop in and give you the exact solution. The simplest Hours collection you can do on a project report is as follows. This will just list the hours, regardless of where they come

[Doug_Den_Hoed__AtAppStore]

David, I think you're spot on with your suggestions with what's available out of the box: collections cannot be sorted or totaled, and your Project Report is a winner - especially if placed on a dashboard, and then a custom tab under Projects so it automatically self-filters when the tab is clicked. Laura, if you'd consider something outside the box, I invite you to consider using our "http://store.atappstore.com/product/ubercalc/">UberCalc solution to sum up the actual hours into Project level custom parameters (e.g. one per role) -- making it easy to then get at using standard Workfront views and reports; or alternatively, our "http://store.atappstore.com/product/capacity-charting/">Capacity Charting solution, which we invented to report on this kind of information in real time (planned and/or capacity and/or actual, summed by year/quarter/month/week or day, per Project etc, by Role etc.) Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

[NRYNR]

I sure hope I'm not the only person who copies these "How To's" into a file for future reference. Most of what I do copy ends up solving a challenge, sometimes years later. Great work!

[lauram26269131]

Thank you, David. This does give me a start. I do think I'll probably have to go to an hours report. I was just hoping to see this done in a project level. I'll take what you gave and see if I can get it to work on my report. Thanks again! Laura Manley Stream Companies

[CommunityUs]

@Laura Manley - were you ever able to find a solution where you totaled the hours? I'm looking to do something similar but with financials and came across your post. Thank you!