Skip to main content
Feb 9, 2017 12:50 AM UTC
Question

How can I create a report that shows only first and second level tasks?

How can I create a report that shows only first and second level tasks?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

14 replies

Level 9
Jun 14, 2017 2:30 PM UTC
Would it help if you just group it by Parent Name ?
Translate
Level 9
Jun 14, 2017 2:39 PM UTC
When I did that it showed parent name and then a number next to it in parenthesis. It didn't even list the subtask.
Translate
Level 9
Jun 14, 2017 2:44 PM UTC

I have just tried and got task with indent between 0 and 1 in filter. And group it by Parent Name. And it seems to work. Unless that's not exactly what you are looking for.

Translate
Level 10
Jun 14, 2017 11:29 PM UTC
Hi Susan, Try using this as your 'Task Name' column (change it to text mode and replace whatever is there with the below): descriptionkey=name displayname=Task isInlineEditable=false link.linkproperty.0.name=ID link.linkproperty.0.valuefield=ID link.linkproperty.0.valueformat=int link.lookup=link.view link.valuefield=objCode link.valueformat=val linkedname=direct listsort=string(name) namekey=task.name.abbr querysort=name section=0 shortview=false stretch=100 textmode=true valueexpression=IF({indent}<1,{name},IF({indent}<2,CONCAT(" - ",{name}),IF({indent}<3,CONCAT(" - - ",{name}),IF({indent}<4,CONCAT(" - - - ",{name}),CONCAT(" - - - - ",{name}))))) valueformat=HTML width=150
Translate