is there any way to set or pass in a variable that will persist through text mode columns in a report? | Community
Skip to main content
Level 2
December 27, 2024
Solved

is there any way to set or pass in a variable that will persist through text mode columns in a report?

  • December 27, 2024
  • 1 reply
  • 459 views

I would love to be able to set a variable value once in text mode in the first column of a report and then repeatedly use that variable throughout the subsequent columns. Is there any way to do this?

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 KellieGardner

@vynetary - if you are using a value expression in your text mode the short answer is no, this is not possible. The results of your value expression aren't stored anywhere in the database of Workfront and it only exists in your column in your report. Kind of like using a basic calculator without the memory buttons. 

 

The workaround is to create calculated fields that live on your custom forms tied to the objects you are reporting on that way the data is "stored" somewhere for reference. 

1 reply

KellieGardner
Community Advisor
KellieGardnerCommunity AdvisorAccepted solution
Community Advisor
December 30, 2024

@vynetary - if you are using a value expression in your text mode the short answer is no, this is not possible. The results of your value expression aren't stored anywhere in the database of Workfront and it only exists in your column in your report. Kind of like using a basic calculator without the memory buttons. 

 

The workaround is to create calculated fields that live on your custom forms tied to the objects you are reporting on that way the data is "stored" somewhere for reference.