For example in a column for a late task report I'm showing the task successor as a valueexpression.
displayname=Next Task
listdelimiter=<br><hr>
listmethod=nested(successors).lists
textmode=true
type=iterate
valueexpression=CONCAT('Task: ',{successor}.{name},' // Task#: ',{successor}.{taskNumber},' //Due Date: ',{successor}.{plannedCompletionDate},' //Task Owner: ',{successor}.{assignedTo}.{name},' //Task Constraint: ',{successor}.{taskConstraint})
valueformat=HTML
This results in the following:
Task: Test late Task 4 // Task#: 4 //Start Date: 2/8/24 //Due Date: 2/14/24 //Task Owner: Stephen Jonas //Task Constraint: FIXT
Task: Test late Task // Task#: 6 //Start Date: 2/1/24 //Due Date: 2/1/24 //Task Owner: Stephen Jonas //Task Constraint: MSO
What Id like to see is something like this. I know I can remove the // but they're currently used to break the content apart.
Task: Test late Task 4
Task#: 4
Start Date: 2/8/24
Due Date: 2/14/24
Task Owner: Stephen Jonas
Task Constraint: FIXT
Task: Test late Task //
Task#: 6 //Start Date: 2/1/24 //
Due Date: 2/1/24 //
Task Owner: Stephen Jonas //
Task Constraint: MSO
Any thoughts?
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Thank you, you sent me in the right direction. This is what I ended up with:
column.46.displayname=Successor Task
column.46.sharecol=true
column.46.textmode=true
column.46.value=<strong>Task Name : </strong>
column.46.valueformat=HTML
column.47.displayname=Next Task Start
column.47.listdelimiter=<div>
column.47.listmethod=nested(successors).lists
column.47.sharecol=true
column.47.textmode=true
column.47.type=iterate
column.47.valueexpression=CONCAT({successor}.{name})
column.47.valueformat=HTML
column.48.sharecol=true
column.48.textmode=true
column.48.value=<br><strong>Task #: </strong>
column.48.valueformat=HTML
column.49.displayname=Task #
column.49.listdelimiter=<div>
column.49.listmethod=nested(successors).lists
column.49.sharecol=true
column.49.textmode=true
column.49.type=iterate
column.49.valueexpression=CONCAT({successor}.{taskNumber})
column.49.valueformat=HTML
column.50.sharecol=true
column.50.textmode=true
column.50.value=<br><strong>Planned Start Date: </strong>
column.50.valueformat=HTML
column.51.displayname=Planned Start Date
column.51.listdelimiter=<div>
column.51.listmethod=nested(successors).lists
column.51.sharecol=true
column.51.textmode=true
column.51.type=iterate
column.51.valueexpression=CONCAT({successor}.{plannedStartDate})
column.51.valueformat=HTML
column.52.sharecol=true
column.52.textmode=true
column.52.value=<br><strong>Planned Completion Date: </strong>
column.52.valueformat=HTML
column.53.displayname=Planned Completion Date
column.53.listdelimiter=<div>
column.53.listmethod=nested(successors).lists
column.53.sharecol=true
column.53.textmode=true
column.53.type=iterate
column.53.valueexpression=CONCAT({successor}.{plannedCompletionDate})
column.53.valueformat=HTML
column.54.sharecol=true
column.54.textmode=true
column.54.value=<br><strong>Assigned to: </strong>
column.54.valueformat=HTML
column.55.displayname=Assigned To
column.55.listdelimiter=<div>
column.55.listmethod=nested(successors).lists
column.55.sharecol=true
column.55.textmode=true
column.55.type=iterate
column.55.valueexpression=CONCAT({successor}.{assignedTo}.{name})
column.55.valueformat=HTML
column.56.sharecol=true
column.56.textmode=true
column.56.value=<br><strong>Task Constraint: </strong>
column.56.valueformat=HTML
column.57.displayname=Task Constraint
column.57.listdelimiter=<div>
column.57.listmethod=nested(successors).lists
column.57.textmode=true
column.57.type=iterate
column.57.valueexpression=CONCAT({successor}.{taskConstraint})
column.57.valueformat=HTML
You would need to do multiple columns for each line you want with a coded line in between to signify the break and then combine into 1 column after they are setup.
this is what it will look like for the first 3 columns as an example in your scenario....
column.1.valueexpression=CONCAT('Task: ',{successor}.{name})
column.1.listdelimiter=<div>
column.1.listmethod=nested(successors).lists
column.1.valueformat=HTML
column.1.displayname=Next Task
column.1.textmode=true
column.1.sharecol=true
column.1.type=iterate
column.2.textmode=true
column.2.sharecol=true
column.2.valueformat=HTML
column.2.value=<div>
column.2.displayname=
column.3.displayname=Next Task
column.3.listdelimiter=<div>
column.3.listmethod=nested(successors).lists
column.3.textmode=true
column.3.type=iterate
column.3.valueexpression=CONCAT('Task#: ',{successor}.{taskNumber})
column.3.valueformat=HTML
Views
Replies
Total Likes
Thank you, you sent me in the right direction. This is what I ended up with:
column.46.displayname=Successor Task
column.46.sharecol=true
column.46.textmode=true
column.46.value=<strong>Task Name : </strong>
column.46.valueformat=HTML
column.47.displayname=Next Task Start
column.47.listdelimiter=<div>
column.47.listmethod=nested(successors).lists
column.47.sharecol=true
column.47.textmode=true
column.47.type=iterate
column.47.valueexpression=CONCAT({successor}.{name})
column.47.valueformat=HTML
column.48.sharecol=true
column.48.textmode=true
column.48.value=<br><strong>Task #: </strong>
column.48.valueformat=HTML
column.49.displayname=Task #
column.49.listdelimiter=<div>
column.49.listmethod=nested(successors).lists
column.49.sharecol=true
column.49.textmode=true
column.49.type=iterate
column.49.valueexpression=CONCAT({successor}.{taskNumber})
column.49.valueformat=HTML
column.50.sharecol=true
column.50.textmode=true
column.50.value=<br><strong>Planned Start Date: </strong>
column.50.valueformat=HTML
column.51.displayname=Planned Start Date
column.51.listdelimiter=<div>
column.51.listmethod=nested(successors).lists
column.51.sharecol=true
column.51.textmode=true
column.51.type=iterate
column.51.valueexpression=CONCAT({successor}.{plannedStartDate})
column.51.valueformat=HTML
column.52.sharecol=true
column.52.textmode=true
column.52.value=<br><strong>Planned Completion Date: </strong>
column.52.valueformat=HTML
column.53.displayname=Planned Completion Date
column.53.listdelimiter=<div>
column.53.listmethod=nested(successors).lists
column.53.sharecol=true
column.53.textmode=true
column.53.type=iterate
column.53.valueexpression=CONCAT({successor}.{plannedCompletionDate})
column.53.valueformat=HTML
column.54.sharecol=true
column.54.textmode=true
column.54.value=<br><strong>Assigned to: </strong>
column.54.valueformat=HTML
column.55.displayname=Assigned To
column.55.listdelimiter=<div>
column.55.listmethod=nested(successors).lists
column.55.sharecol=true
column.55.textmode=true
column.55.type=iterate
column.55.valueexpression=CONCAT({successor}.{assignedTo}.{name})
column.55.valueformat=HTML
column.56.sharecol=true
column.56.textmode=true
column.56.value=<br><strong>Task Constraint: </strong>
column.56.valueformat=HTML
column.57.displayname=Task Constraint
column.57.listdelimiter=<div>
column.57.listmethod=nested(successors).lists
column.57.textmode=true
column.57.type=iterate
column.57.valueexpression=CONCAT({successor}.{taskConstraint})
column.57.valueformat=HTML
This whole report seems amazing and I'm wondering if you'd share its use case and the type of text mode you're using for the columns? Is it a collection report for a project? I'm looking for something similar... Thank you!
Views
Replies
Total Likes
The report was to help the project managers view their late task and see the next task. This allowed the project managers to review and edit their task in one screen without having to open each project individually. The highlighted field allow the owner the ability to edit and log reasons for the date change.
Views
Replies
Total Likes
This is honestly amazing and my company could totally benefit - is it too much to ask for all of the text modes please? Happy to chat over email as well if that's easier. I feel like I'd spin my wheels for days trying to recreate. Thank you!
Views
Replies
Total Likes
See attached
Views
Replies
Total Likes
Thank you SO much!!
Views
Replies
Total Likes
No problem. Let me know if there are other types of reports your looking for, and I can see what I have.
Views
Replies
Total Likes
@sljonashi
I am grateful that you provided the zip file for the extensive code you use within that project report, but I was running into errors whenever I tried adding the text mode code for the 2nd column. Do you know why that might be? I fixed what I assumed was a typo in the first line, but I still had issues (column.12.colunm.7.sharecol=true).
Thanks so much!
Views
Replies
Total Likes
Delete from the second column the first line.
column.12.colunm.7.sharecol=true
Views
Replies
Total Likes
I still get an error with that line removed for second column. Has anyone else tried this report out and had the same issue, or is it just me?
column.12.displayname=Project Status
column.12.sharecol=true
column.12.textmode=true
column.12.value=<strong>Project Condition: </strong>
column.12.valueformat=HTML
column.12.width=1
column.13.displayname=
column.13.enumclass=com.attask.common.constants.ProjectConditionEnum
column.13.enumtype=PROJ
column.13.linkedname=project
column.13.namekey=view.relatedcolumn
column.13.namekeyargkey.0=project
column.13.namekeyargkey.1=condition
column.13.querysort=project:condition
column.13.sharecol=true
column.13.textmode=true
column.13.tile.height=12
column.13.tile.name=component.conditionview
column.13.type=enum
column.13.valuefield=project:condition
column.13.valueformat=val
column.14.sharecol=true
column.14.textmode=true
column.14.value=<br><hr><strong>Progress Status: </strong></hr>
column.14.valueformat=HTML
column.15.displayname=
column.15.enumclass=com.attask.common.constants.ProjectStatusEnum
column.15.enumtype=PROJ
column.15.linkedname=project
column.15.namekey=view.relatedcolumn
column.15.namekeyargkey.0=project
column.15.namekeyargkey.1=status
column.15.querysort=project:status
column.15.sharecol=true
column.15.textmode=true
column.15.type=enum
column.15.valuefield=project:status
column.15.valueformat=val
column.16.sharecol=true
column.16.textmode=true
column.16.value=<hr><strong>Projected Start Date: </strong>
column.16.valueformat=HTML
column.17.displayname=
column.17.linkedname=project
column.17.namekey=view.relatedcolumn
column.17.namekeyargkey.0=project
column.17.namekeyargkey.1=projectedStartDate
column.17.querysort=project:projectedStartDate
column.17.sharecol=true
column.17.textmode=true
column.17.valuefield=project:projectedStartDate
column.17.valueformat=atDate
column.18.sharecol=true
column.18.textmode=true
column.18.value=<br><strong>Projected Completion Date: </strong>
column.18.valueformat=HTML
column.19.displayname=
column.19.linkedname=project
column.19.namekey=view.relatedcolumn
column.19.namekeyargkey.0=project
column.19.namekeyargkey.1=projectedCompletionDate
column.19.querysort=project:projectedCompletionDate
column.19.sharecol=true
column.19.textmode=true
column.19.valuefield=project:projectedCompletionDate
column.19.valueformat=atDate
column.20.sharecol=true
column.20.textmode=true
column.20.value=<hr><strong>Project % Completed: </strong>
column.20.valueformat=HTML
column.21.sharecol=true
column.21.textmode=true
column.21.valueformat=HTML
column.22.displayname=
column.22.linkedname=project
column.22.namekey=view.relatedcolumn
column.22.namekeyargkey.0=project
column.22.namekeyargkey.1=percentComplete
column.22.querysort=project:percentComplete
column.22.textmode=true
column.22.tile.name=component.percentcompletelistview
column.22.type=tile
column.22.valuefield=project:percentComplete
column.22.valueformat=doubleAsPercentRounded
Views
Replies
Total Likes
Andrew,
I was able to copy the text mode for the column into a blank report and it worked. I can get on a call with you if you'd like. You can also email me stephen_jonas@hmsa.com to discuss more.
Views
Replies
Total Likes
Views
Like
Replies
Views
Likes
Replies