Hiding Blank Fields

[WelshTeckie]

Hi There,

This is probably the simplest thing, but I am totaly new to CR so I have no idea how to do even the most basic things.

So here's what I'm trying to do. I have figured out how to supress the "Detail" sections if its blank. But I have have 3 fields in "Details a" which are

Title Name Surname
Mr Welsh Teckie

and I want to supress and join the fields together if they differ in size or if are blank

So if all were populated it would output
Mr Welsh Teckie

And if name was blank it would output
Mr Teckie

I have looked through this forum and everyone seems to be more advanced than me, so if you can help me out that would be great!

 

[lbass]

Create a formula in the field explorer->formula->new:

(
if isnull({table.title}) then
"" else
{table.title}
) +
(
if isnull({table.name}) then
"" else
{table.name}
) +
(
if isnull({table.surname}) then
"" else
{table.surname}
)

Place this in your details section instead of the fields.

-LB

 

[WelshTeckie]

Thats excelent.

Thankyou very much, their looking much better already, could you tell me what is the syntax for new line.

I am doing address labels, and instead of

here, there, everywhere,

I would rather

here,
there,
everywhere,

using the same formula you gave me before with a new field

 

[lbass]

Please describe the full problem initially, instead of adding on requirements.

(
if isnull({table.title}) then
"" else
{table.title}+chr(13)
) +
(
if isnull({table.name}) then
"" else
{table.name}+chr(13)
) +
(
if isnull({table.surname}) then
"" else
{table.surname}+chr(13)
)

This would give you:

Mr
Welsh
Teckie

-LB

 

[WelshTeckie]

Thankyou,

Sorry for not specifying requirement on the first post.


Thanks again...