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
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