Conditional text

[gerard]

I need my sales orders and invoices to always print the customer billing address and, in a separate area on the sales order/invoice, the delivery address (when different to the billing address).

However, when the billing and delivery addresses are the same, I want the billing address to also be printed in the delivery address field.

I am pretty sure that this will be done by making the delivery address field conditional- probably using an ‘if, is blank’ expression - I am familiar with the syntax in excel but not report designer.

Can anyone help me on this?

Thanks

[brucedenney]

I think what you are asking for is the Invoice address to be printed in the delivery address when the delivery address is blank.

I suggest that the way to do this is

In the place where the delivery name would be enter an expression
It would compare all the delivery fields added together to a blank and if blank then print the Invoice name, otherwise print the delivery name.
Repeat for each of the five address lines.