Display record based on a condition

[veles]

Hi,
I am using Crystal XI and I need a bit of help on a formula.

I have Clients that might have a physical and/or mailing address. All clients have a physical address.

I need a formula that will look through the records and if a client has a mailing address to display it if not to display the physical address.

Is it possible to display it in the page header?

Thanks

 

[kray4660]

It would be something like this. The field names are examples.

if len({Mailing_address}) <>0 then {Mailing_Address} else {Physical_Address}