Level 4

Solved

Does anyone have the text code to add a column in a report for the date a predecessor task was completed?

Forum|Forum|5 years ago
June 20, 2020
5 replies
1158 views

One of our users would like a column added to his task report that displays the date the predecessor task was completed.

The standard list of column options does not include this. Do any of you have a text mode way of accomplishing this?

I come from a design background and not coding so this is my weakness. But I really enjoy trying to solve these issues and build our best version of WF possible.

I appreciate any help you can provide.

Thank you

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

Best answer by TracyPa2

I did some digging through articles on here. I couldn't find exactly what i was looking for but i was able to find a code that I altered slightly and it works.

I'm going to leave this post up in case this helps anyone else. Here is the code I used:

displayname=Predecessors Completion Dates

listdelimiter=<br>

listmethod=nested(predecessors).lists

textmode=true

type=iterate

valueexpression={predecessor}.{actualCompletionDate}

valueformat=HTML

T

TracyPa2AuthorAccepted solution

Level 4

I did some digging through articles on here. I couldn't find exactly what i was looking for but i was able to find a code that I altered slightly and it works.

I'm going to leave this post up in case this helps anyone else. Here is the code I used:

displayname=Predecessors Completion Dates

listdelimiter=<br>

listmethod=nested(predecessors).lists

textmode=true

type=iterate

valueexpression={predecessor}.{actualCompletionDate}

valueformat=HTML

Doug_Den_Hoed__AtAppStore

Community Advisor

Well done Tracy!

Since you enjoy noodling these out, I invite you to review this related post, which builds on the concept you just applied.

Regards,

Doug

T

TracyPa2Author

Level 4

Hmmm, I've been trying this on several different reports and even created a brand new project report but the fields are always empty. Haven't been able to solve the riddle yet...

kynabaker16

Adobe Employee

I second Doug! Well done, Tracy. You sound like you're getting more and more familiar with this type of work every day, even though it isn't your background.

N

NRYNR

Level 10

Good stuff everyone. This solution has been documented in the WFPro Text Mode Examples report.