Looking for help on a task report. | Community
Skip to main content
NicoleFi1
Level 2
Jan 25, 2022 10:11 PM UTC
Question

Looking for help on a task report.

Does anyone know how to display a list of tasks, the planned completion date of those tasks along with that tasks predecessors and their predecessors planned completion date?

Example

Task Name Planned Completion Date Predecessor Predecessor Planned Completion Date

Task 1 1/25/22 3 3/15/22

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

imgrund
imgrund
Employee
Jan 25, 2022 10:20 PM UTC

Hi Nicole, a task can have multiple predecessors so you need to do a collection.

I have this text mode I've used in the past. It should the task number, name, and planned completion date of the predecessors for a task

displayname=Predecessors

listdelimiter=<br>

listmethod=nested(predecessors).lists

textmode=true

type=iterate

valueexpression=CONCAT("(",{predecessors}.{taskNumber},") ",{predecessors}.{name}," - ",{predecessors}.{plannedCompletionDate})

valueformat=HTML

Hope that helps.

Translate
    NicoleFi1Author
    Level 2
    Jan 26, 2022 10:13 PM UTC

    Thanks so much! Unfortunately, this did not work for me.

    It didn't error out or produce a report.

    Translate
      imgrund
      imgrund
      Employee
      Jan 27, 2022 2:04 PM UTC

      Hi Nicole, So sorry... the code was wrong. #facepalm

      displayname=Predecessors

      listdelimiter=<br>

      listmethod=nested(predecessors).lists

      textmode=true

      type=iterate

      valueexpression=CONCAT("(",{predecessor}.{taskNumber},") ",{predecessor}.{name}," - ",{predecessor}.{plannedCompletionDate})

      valueformat=HTML

      Here is what it looks like:

      Translate
      Terms & ConditionsAccessibility statement

      Loading footer...