suppress text in detail section

[jobillborf]

Hi I have a "&" (text) in the details section that I would like to suppress it the field Addrxtra.St2name is null.

Thank you

 

[synapsevampire]

Right click the field and select Format Field. Now click the X-2 next to the Suppress.

place the following in there:

isnull(Addrxtra.St2name)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[jobillborf]

Ken Im sorry but it did not work. The & is text not a field. Thank you

 

[synapsevampire]

Text can also be suppressed, right click and select format field->Common (Tab)->Suppress->X-2.

If you still have problems, just build a formula to contain the text and use:

@My&text
If isnull(Addrxtra.St2name)
""
else
"&"

And I'm Kai, not Ken, Ken's the olde timer here.

<flashin' a wicked lil grin at Ken>

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[synapsevampire]

BTW, if this is separating two fields, consider just building a formula to house both fields and the & text:

@My&text
If isnull({Addrxtra.St2name})
{Addrxtra.St1name}
else
{Addrxtra.St1name} + &quot;&&quot; + {Addrxtra.St2name}

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[jobillborf]

Thank you for your help.