Suppressing Fields

[Former Member]

Hi All,

I've kept four fields inside a text object. Is it possible to suppress the fields inside a text object? (CR2008)
Example:
Field1 - Eng Name - Peter Lee
Field2 - Birth - 20/5
Field3 - Age - M
Field4 - Comma ( , )

I've put those fields inside a text object like this:
{Field1}{Field4}{Field2}{Field4}{Field3}
Result: Peter Lee , 20/5 , M

Now I want to suppress last two fields {Field4}{Field3} if {Field3} is null
Result: Peter Lee , 20/5

As the suppress function of field in text object was disappeared. How can I do this?

[abhilash_kumar · Accepted solution]

Hi Divya,

You'll need to create a formula field to get the desired result.

if isnull({field3}) then

     {Field1}&{Field4}&" "&{Field2}

else

     {Field1}&{Field4}&" "&{Field2}&{Field4}&" "&{Field3}

Then use the formula field in the Text Object.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

Thank you

Small information can i view all my threads i created in this forum ?.Please suggest

[abhilash_kumar · Accepted solution]

To view your threads, click your name and go to the 'Content' tab.

-Abhilash