Topic Options
#24382 - 04/08/08 03:14 AM How to skip empty field
ocehk Offline
Junior Member

Registered: 04/08/08
Posts: 2
Loc: Hong Kong
I want to print the standard Name and Address format, like this
Title FName LName
Address 1
Address 2
Address 3

If Address 2 is blank, how may I print it like this:
Title FName LName
Address 1
Address 3

i.e. Address 2 is skip and Address 3 is move up 1 line.

Any one can help?

Top
#24383 - 04/08/08 03:20 AM Re: How to skip empty field
Anonymous
Unregistered


There is a few things to take into account when trying to skip emtpy lines:

1) When you select a text box, you can see an option in the properties for "skip empty lines". Set this to "yes"

2) An empty line really means an empty line; if a data field contains a space it's not empty. If you type spaces on a line, it's not empty, if you add spaces in an expression, it's not empty.

For example a line with:
@var1@ @var@
is not empty; a space was typed. In this case, use one variable, and use the expression builder to fill it with multiple data fields, and only spaces if both fields are not empty.

Also, it is recommended to trim all data from datafields. For example, if @var1@ should contain [field1], use the expression TRIM([field1]) to clear any spaces/tabs from both sides of the data field.

Top
#24384 - 06/11/08 01:38 PM Re: How to skip empty field
Curtis Offline
Junior Member

Registered: 06/11/08
Posts: 1
I'm new with this, can someone help?

When changing my properties and to print skipped lines it only shows page #2.

How do you trim the data fields exactly?

Top
#24385 - 06/12/08 03:24 PM Re: How to skip empty field
Anonymous
Unregistered


Curtis,
to trim a data field, edit an expression and use the TRIM function.
The expression will look like this:
TRIM([datafield_name])

Top