How To Display Conditional Results - Crystal Reports

[AnilJ]

Hello.
Have a question that may or may not be doable within Crystal.

I have 3 different records within a database and I want to display information only if it meets my condition.

So for example, the records are invemail, salesemail, faxnumber in database AREMAIL.

I would like to have a formula that will look at the first record (invemail) and if there is an email in there (*@* format, because sometimes there are just words in there that I don't want to see, only an email) display it, if not, then look in salesemail, if an email is in there (again in the format of *@*) display it, if not then display what is in the record faxnumber.

So hopefully the formula will know that if it finds an email in the first record it will display that one only and stop there, even though there may be an email within the second record and a fax number in the 3rd.

I hope that makes sense.

Any help with this would be appreciated, if it is possible.

Thank you very much for your time,
AJ

 

[pmax9999]

Create a formula like this:

[Code email]
If {Table.invemail} like '*@*'
Then {Table.invemail}
Else
If {Table.salesemail} like '*@*'
Then {Table.salesemail}
Else {Table.faxnumber}
[/Code]

Cheers
Pete

 

[AnilJ]

Hi Pete,

Thank you very much for the formula, it worked out perfectly for me (I just needed to change the faxnumber record to a totext to get it to display) but your help was just what I needed to get it to work.

Thanks again for your time and help.

Regards,

AJ