Task Report to only show Hours for a certain Hour Type

Question

Working on a report and I only want it to bring in a certain hour type's actual hours - basically take Actual Work Required and remove any hours of a certain type. I want to have it as a column header, since I want all tasks to show even if they do not have hours for that Hour Type. I have been trying to come up with a solution and just want to make sure this is even possible? I think it should work since Hours and their details are found at the Task level. Or maybe not since it is trying to bring in many to one (many hour entries to one task)? Thanks!

Sven-iX · Accepted Answer

Technically doable but it'll be a resource intensive (slow) report if you have good amount of hours logged against tasks. Do a task reportthen in one column you can iterate over the task's hours collectionin that iterator, you'll need to use a value expression to suppress by type. For examplevalueexpression=if({hourType}.{name}!="New hour type",{hours} + ": " + {hourType}.{name})listdelimiter=
listmethod=nested(hours).listsvalueformat=HTMLdisplayname=All hourstype=iterate

サインアップ

ソーシャルログイン

コミュニティへログイン

ソーシャルログイン