Forum Discussion

TeresaRay's avatar
TeresaRay
Qrew Member
6 years ago

Hiding a Linked Report Field when there are no values

I tried to do an argument to hide the linked reports if there weren't any values but they are still showing on my project profile. Is there a way to hide a table report embedded in a project profile i...
Formulas and functions
Relationships
TeresaRay's avatar
TeresaRay
Qrew Member
6 years ago
Thanks for the response Laura. 

It's not a numeric value so the summary field would be difficult to use as I am not trying to count the child records, I just want to display the information as is.  Sorry for not being more specific - What I have is three different fields capturing the same table, just displaying different columns. I don't want the profile to display all three of them at once so if either one of the others have information in them, I want to hide the other two.  Is there a way to hide two fields if the third one has information?

------------------------------
Teresa Ray
------------------------------
Laura_Thacker's avatar
Laura_Thacker
Qrew Commander
6 years ago
Teresa,

So what you really need is a formula field in your table of records which "compiles" the value from one of the 3 relationships into a single value that you can display as a single column in your embedded report.

In this case, you can build a formula-text field.  Let's just assume you want to display the proxy-field value from one of the three relationships to determine which "parent" the record is connected to.

Formula-Text field: [Parent Record]

List(",",[Related Reference Field 1 Proxy],[Related Reference Field 2 Proxy],[Related Reference Field 3 Proxy])​

This formula will display the proxy field value from the only relationship that is populated, for a single-output formula.




------------------------------
Laura Thacker (IDS)
laura@intelligentdbs.com
(626) 771 0454
------------------------------