Is there a way to add text formatting in a valueexpression. | Community
Skip to main content
S
sljonashi
Level 4
February 1, 2024
Solved

Is there a way to add text formatting in a valueexpression.

  • February 1, 2024
  • 2 replies
  • 2162 views

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?

Best answer by sljonashi

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

 

 

2 replies

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
February 1, 2024

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

 

 

S
sljonashiAuthorAccepted solution
Level 4
February 2, 2024

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

 

 

    G
    GrahamSp2
    Level 2
    May 12, 2025

    This method seems to work for display but when I export a PDF of it the field values seems to be missing. Any idea how to make a report like this print correctly?

    J
    Jcosta16
    Level 2
    April 8, 2024

    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!

    S
    sljonashiAuthor
    Level 4
    April 8, 2024

    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.

    S
    sljonashiAuthor
    Level 4
    April 23, 2024

    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


    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.

    Terms & ConditionsAccessibility statement

    Loading footer...