Expression Building

rbuser

Dear Group

I am a first time user of this report designer. I have an invoice template
which I would like to alter. It is the Name and Address part that I wish to
change. At the moment it looks as follows and is bound to my orders table.

invoice name
invoice address 1
invoice address 2
invoice state
invoice zip

Each of the above fields are in their own dbtext box. What I would like to
do is make it so the address can be trimmed as in MS Access. Therefore I
wish to build an expression that will cut out parts that are not applicable
to some addresses. For example shorter addresses that do not have any value
for address 2. I would like the expression to shift the invoice state up to
the next line automatically. Therefore this does not leave my invoice with
a blank line between address 1 and state. If there is a way that I can just
build an expression that does this in a dbtext box then please let me know
how. I have read some of the learnreportbuilder.pdf but can not seem to
find much on this. The part I can see in the mailing labels section about a
calcs tab which I can not seem to find. Please if anyone can offer any
help, or maybe even a template with this sort of expression in so I can see
it.

Thanks in advance to any that help.

Kind Regards

Fay