Report - Merge column with row separate | Community
Skip to main content
Donna_Boj
Donna_Boj
Level 3
June 10, 2025
Solved

Report - Merge column with row separate

  • June 10, 2025
  • 2 replies
  • 391 views

Hello All,

Hoping someone can assist, I need to combine 5 fields into one column on a report but I need the outputs to display on separate rows.

These are the fields names:
ccoInclusionName1
ccoInclusionName2
ccoInclusionName3
ccoInclusionName4
ccoInclusionName5

I have made a start but struggling to add the other fields and I can't find the correct syntax for the separate row break.
If someone can assist me with completing this, it would be a big help.

column.17.displayname=Inclusion Name
column.17.linkedname=direct
column.17.namekey=ccoInclusionName1
column.17.querysort=DE:ccoInclusionName1
column.17.sharecol=true
column.17.textmode=true
column.17.valuefield=ccoInclusionName1
column.17.valueformat=customDataLabelsAsString
column.18.linkedname=direct
column.18.namekey=ccoInclusionName2
column.18.querysort=DE:ccoInclusionName2
column.18.textmode=true
column.18.valuefield=ccoInclusionName2
column.18.valueformat=customDataLabelsAsString

Many thanks,

Best answer by _Manish_Singh

Hello @donna_boj, Please refer to 'Merge columns with a link break' section in this article: View: Merge Information from Multiple Columns in One Shared Column | Adobe Workfront

2 replies

_Manish_Singh
_Manish_SinghAccepted solution
Level 9
June 10, 2025

Hello @donna_boj, Please refer to 'Merge columns with a link break' section in this article: View: Merge Information from Multiple Columns in One Shared Column | Adobe Workfront

    _Manish_Singh
    _Manish_Singh
    Level 9
    June 10, 2025

    I think you can further enhance the readability by adding the field name and its value.
    Example: 
    Inclusion 1: value 1
    Inclusion 2: value 2

    and so on...

    column.17.displayname=CCO Inclusions column.17.sharecol=true column.17.textmode=true column.17.usewidths=true column.17.value=<strong></strong> column.17.valueformat=HTML column.17.width=350 column.18.sharecol=true column.18.textmode=true column.18.value=<strong>Inclusion 1: </strong> column.18.valueformat=HTML column.19.linkedname=direct column.19.namekey=ccoInclusionName1 column.19.querysort=DE:ccoInclusionName1 column.19.sharecol=true column.19.textmode=true column.19.valuefield=ccoInclusionName1 column.19.valueformat=customDataLabelsAsString column.20.sharecol=true column.20.textmode=true column.20.value=<br><strong>Inclusion 2: </strong> column.20.valueformat=HTML column.21.linkedname=direct column.21.namekey=ccoInclusionName2 column.21.querysort=DE:ccoInclusionName2 column.21.sharecol=true column.21.textmode=true column.21.valuefield=ccoInclusionName2 column.21.valueformat=customDataLabelsAsString column.22.sharecol=true column.22.textmode=true column.22.value=<br><strong>Inclusion 3: </strong> column.22.valueformat=HTML column.23.linkedname=direct column.23.namekey=ccoInclusionName3 column.23.querysort=DE:ccoInclusionName3 column.23.sharecol=true column.23.textmode=true column.23.valuefield=ccoInclusionName3 column.23.valueformat=customDataLabelsAsString column.24.sharecol=true column.24.textmode=true column.24.value=<br><strong>Inclusion 4: </strong> column.24.valueformat=HTML column.25.linkedname=direct column.25.namekey=ccoInclusionName4 column.25.querysort=DE:ccoInclusionName4 column.25.sharecol=true column.25.textmode=true column.25.valuefield=ccoInclusionName4 column.25.valueformat=customDataLabelsAsString column.26.sharecol=true column.26.textmode=true column.26.value=<br><strong>Inclusion 5: </strong> column.26.valueformat=HTML column.27.linkedname=direct column.27.namekey=ccoInclusionName5 column.27.querysort=DE:ccoInclusionName5 column.27.sharecol=true column.27.textmode=true column.27.valuefield=ccoInclusionName5 column.27.valueformat=customDataLabelsAsString

     

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    September 22, 2025

    @donna_boj  we noticed your question and invite you to our [Workfront AMA] Ask Me Anything about Workfront System Smarts & Strategic Starts on Wed, Oct 29, 2025 | 9–10 AM PDT. Experts will answer questions on topics like: day-to-day system tasks, strategic planning, Reporting, Adoption, System Maintenance, Notifications, Governance, Roadmapping, and Custom Forms. Post your questions in advance to ensure they’re answered. Reminder: All AMAs are TEXT-ONLY—no video or recording. RSVP & submit questions in advance here: https://adobe.ly/46xKfHM 

    Kautuk Sahni
    Terms & ConditionsAccessibility statement

    Loading footer...