How to display a task date in the column on a task report? | Community
Skip to main content
B
BenettaPe
Level 9
August 24, 2020
Question

How to display a task date in the column on a task report?

  • August 24, 2020
  • 3 replies
  • 1038 views

I can't find the error in this syntax. This should work. Please review and help me to see the syntax error.

This is a task report. I have a task named "Full Access Target Date Flag". I am just trying to show the planned completion date of that task, in the column of this task report.

At this point, I'm not showing anything else, just trying to get this 1st step correct.

displayname=Full Access Target Date

listmethod=nested(tasks).lists

textmode=true

type=iterate

valueexpression=IF({name}="Full Access Target Date Flag",{plannedCompletionDate})

valueformat=HTML

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

    3 replies

    Doug_Den_Hoed__AtAppStore
    Community Advisor
    Doug_Den_Hoed__AtAppStoreCommunity Advisor
    Community Advisor
    August 24, 2020

    Hi Benetta,

    I think your syntax is correct, provided it is used on a column in a Project report: listmethod=nested allows you to enumerate 1:many relationships “under” an object, such as Project:Tasks, Task:Assignees, Issue:Hours, etc.

    Regards,

    Doug

      B
      BenettaPeAuthor
      Level 9
      August 24, 2020

      It is a TASK report. How can I get this information in a TASK report? Thanks.

      A
      AdinaPi1
      Level 9
      August 24, 2020

      Hi Benetta, try this:

      displayname=Full Access Target Date

      linkedname=direct

      namekey=plannedCompletionDate

      querysort=plannedCompletionDate

      textmode=true

      valueexpression=IF({name}="Full Access Target Date Flag",{plannedCompletionDate},"")

      valueformat=atDate

      B
      BenettaPeAuthor
      Level 9
      August 24, 2020

      Adina, I tried it in the "task" report, but it did not work.

      Now I am creating a "project" report as Doug said it has to be and go from there to bring up the various tasks that I'm trying to bring up. Thanks.

      A
      AdinaPi1
      Level 9
      August 24, 2020

      Hi Benetta, I tried it in a task view on the project, and it worked there...it should work in a task report too. Check my screenshot to make sure I understood the ask correctly.

      B
      BenettaPeAuthor
      Level 9
      August 24, 2020

      Yes this is correct, as I want it to display in a Task report. Let me look at your syntax again, as I did a cut and paste.

      Terms & ConditionsAccessibility statement

      Loading footer...