Direct Reports values not displaying in exported report (Excel) | Community
Skip to main content
Level 1
March 17, 2026
Solved

Direct Reports values not displaying in exported report (Excel)

  • March 17, 2026
  • 1 reply
  • 34 views

Hi All,

 

I created a user report and added a ‘Direct Reports’ column using the following text mode:

 

displayname=Direct Reports
listdelimiter=<br>
listmethod=nested(directReports)
type=iterate
valuefield=name
valueformat=HTML

 

The column displays correctly within the Workfront report and successfully shows all direct report names.

 

However, when exporting the report to Excel, the Direct Reports column appears blank.

 

Please advise whether this is a known system limitation, or if the issue can be resolved by adjusting the text mode configuration?

 

Any guidance or recommendations would be greatly appreciated. Thank you.

 

Best regards,

Lyon Lye

    Best answer by Richard_Le_

    Hi,

    Try adjusting your textmode to the following, you should find that the values then export correctly:

     

    displayname=Direct Reports
    listdelimiter=<br>
    listmethod=nested(directReports).lists
    type=iterate
    valuefield=name
    valueformat=HTML

     

    Best Regards,

    Rich
     

    1 reply

    Richard_Le_Community AdvisorAccepted solution
    Community Advisor
    March 18, 2026

    Hi,

    Try adjusting your textmode to the following, you should find that the values then export correctly:

     

    displayname=Direct Reports
    listdelimiter=<br>
    listmethod=nested(directReports).lists
    type=iterate
    valuefield=name
    valueformat=HTML

     

    Best Regards,

    Rich
     

    LyonLyeAuthor
    Level 1
    March 19, 2026

    Hi Richard Leek,

     

    Thank you for the information provided.


    We were able to export the ‘Direct Reports’ values successfully using the adjusted text mode, and the results are as expected.


    We truly appreciate your guidance.

     

    Best regards,

    Lyon Lye