Skip to main content
D
DaveBi
February 9, 2017
Question

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

  • February 9, 2017
  • 14 replies
  • 1845 views
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

Show previous replies
D
DagmaraGa
Level 9
June 14, 2017
Would it help if you just group it by Parent Name ?
S
SusanPf
Level 9
June 14, 2017
When I did that it showed parent name and then a number next to it in parenthesis. It didn't even list the subtask.
D
DagmaraGa
Level 9
June 14, 2017

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.

D
DavidCo3
Level 10
June 14, 2017
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
Terms & ConditionsAccessibility statement

Loading footer...