Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Showing Subtask View in Reports


Level 6
Hello, I think I have asked this before, but do not recall. Is there a way to show the parent/child relationships (subtasks) in a report? This would be very beneficial for numerous reports of mine, so I am trying to figure it out. Thanks, Tim Tim Brooks Invicro
0 Replies


Level 10
Hi @Tim Brooks - can you elaborate a little more on your requirements (especially in terms of how you want to present the report)? You can identify parent and child tasks when filtering by using the 'Number of Children' field on tasks, in conjunction with the 'Indent' field: If Number of Children is 0, and indent is greater than 0, then it is a child task. If Number of Children is greater than 0 then it is a parent task. If Number of Children is 0 and Indent is 0 then it is neither a parent task or a child task. Conversely, if Number of Children and Indent are both greater than 0, then it is both a parent and child task. Regards, David. David Cornwell


Level 6
Hello @David Cornwell , I am actually not trying to filter out anything, I would like to show all tasks in the report, but within the report physically show the parent/child relationships. I actually figured it out since I last sent. It is a series of text mode code within task name. I actually got it to highlight the parent tasks in different colors based on how many indents that parent task is, AND have tick marks next to the task name to show how many indents the specific task is. Example below. Tim Brooks Invicro


Level 3

Hi Tim,

would you mind sharing the text mode code you used to solve this issue?

I have exactly the same challenge.

Thanks a lot in advance.




Level 6

Here ya go!






valueexpression=IF({indent}<1,{name},IF({indent}<2,CONCAT(" - ",{name}),IF({indent}<3,CONCAT(" - - ",{name}),IF({indent}<4,CONCAT(" - - - ",{name}),CONCAT(" - - - - ",{name})))))




Level 1

This is awesome Tim! When I use the text mode the formatting works perfectly. Quick question: are you able to sort the tasks by the order in which they're displayed in the project plan? Right now the tasks have the correct formatting the the order appears random.


Level 1

Yes, in the project plan I'm sorted by the Task number and it shows the parent-child task relationship. I'm not sure how to sort by task number in the report view.


Level 1

Actually I just figured it out. I added the Task Number field as a column and then sorted by that column. Thank you so much Tim! You saved me so much time.