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 22, 2024

    @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!

     

     

    Delete from the second column the first line.

     

    column.12.colunm.7.sharecol=true

    Terms & ConditionsAccessibility statement

    Loading footer...