Report cell size management in Workfront reports | Community
Skip to main content
N
NishaPatel
Level 3
May 24, 2023
Solved

Report cell size management in Workfront reports

  • May 24, 2023
  • 2 replies
  • 1610 views

In the reports, sometimes the cell size becomes too large, making the report unreadable. Can we resize the cell size to auto fit to a required dimension and let the entire field load only if needed. Something like (..) in the end of fixed character limit?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by J_Mas

If you're trying to control the width of a cell on a report, in Text-Mode you can add the code:

usewidths=true

width=400

And then just adjust the number (in my example, 400) to be the width that you'd like to set for your column.

 

If you're trying to limit the amount of text returned in a cell, try something like this in Text Mode (which I got from one of @moniqueevans example reports):

valueexpression=IF(LEN({lastNote}.{noteText})>350,CONCAT(SUBSTR({lastNote}.{noteText},0,349),"...(open for more) --"),IF(LEN({lastNote}.{noteText})>0,CONCAT({lastNote}.{noteText})))

In the above example, if the length of the note is more than 350 characters, the formula will only display the first 350 characters followed by "...(open for more) --"

2 replies

J_Mas
J_MasAccepted solution
Level 5
May 24, 2023

If you're trying to control the width of a cell on a report, in Text-Mode you can add the code:

usewidths=true

width=400

And then just adjust the number (in my example, 400) to be the width that you'd like to set for your column.

 

If you're trying to limit the amount of text returned in a cell, try something like this in Text Mode (which I got from one of @moniqueevans example reports):

valueexpression=IF(LEN({lastNote}.{noteText})>350,CONCAT(SUBSTR({lastNote}.{noteText},0,349),"...(open for more) --"),IF(LEN({lastNote}.{noteText})>0,CONCAT({lastNote}.{noteText})))

In the above example, if the length of the note is more than 350 characters, the formula will only display the first 350 characters followed by "...(open for more) --"

    N
    NishaPatelAuthor
    Level 3
    June 5, 2023

    Hi J_Mas,

     

    I am sorry but the same code is not usable for Description field that I am pulling through from a custom form. Can you tell what get replaced in the above formula with the custom field name?

     

    Thanks,

    Nisha

    J_Mas
    J_Mas
    Level 5
    June 5, 2023

    You should only need to replace {lastNote}.{noteText} with the name of your field, such as {project}.{description} or perhaps just {description} depending on the type of report you're building.

    Also, If you copy/pasted the formula from my earlier post, you may need to delete the quotes from the formula and then manually type them. I've had some instances where copying quotation marks from one source and then pasting them in another can give you the wrong quotation marks.

    Finally, if you haven't already done so, I'd suggest watching the Advanced Reporting video where Monique showed off this great formula. She gets to this particular formula around 18:18, but it's worth watching the whole video.

      N
      NishaPatelAuthor
      Level 3
      June 30, 2023

      Hi @j_mas ,

       

      I tried the same formula on one of my custom fields on a Request report where the formula looks something like below:

      displayname=Description
      linkedname=direct
      namekey=Description - please provide detail on your request
      textmode=true
      valueexpression=IF(LEN({Description - please provide detail on your request})>350,CONCAT(SUBSTR({Description - please provide detail on your request},0,349),"...(open for more) --"),IF(LEN({Description - please provide detail on your request})>0,CONCAT({Description - please provide detail on your request})))
      valuefield=Description - please provide detail on your request
      valueformat=HTML

       

      The custom field is "Description - please provide detail on your request"

       

      Can you tell what looks incorrect in this particular formula?

       

      Thanks,

      Nisha

      Terms & ConditionsAccessibility statement

      Loading footer...