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.

    J
    Jcosta16
    Level 2
    April 9, 2024

    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!

    Terms & ConditionsAccessibility statement

    Loading footer...