if-then-else not working ?

[lynchdog]

I for the life of me can not figure out what is wrong with this formula. It appears that the only thing being evaluated is the very first line of the if statement and nothing beyond that. I appreciat any help on this one...
Thanks, Josh

if {FORMATTEDTRANS.TYPE_69_STATUS} = "MATCH" or
{FORMATTEDTRANS.TYPE_70_STATUS} = "MATCH" or
{FORMATTEDTRANS.TYPE_71_STATUS} = "MATCH" then "Image Displayed: Accepted" else
if {FORMATTEDTRANS.TYPE_69_STATUS} = "NOMATCH" or
{FORMATTEDTRANS.TYPE_70_STATUS} = "NOMATCH" or
{FORMATTEDTRANS.TYPE_71_STATUS} = "NOMATCH" and
{FORMATTEDTRANS.TYPE_72_STATUS} = "DL" then "Image Displayed: Re-Scanned" else
if {FORMATTEDTRANS.TYPE_69_STATUS} = "NOMATCH" or
{FORMATTEDTRANS.TYPE_70_STATUS} = "NOMATCH" or
{FORMATTEDTRANS.TYPE_71_STATUS} = "NOMATCH" and
{FORMATTEDTRANS.TYPE_72_STATUS} = "" then "Image Displayed: Not Accepted" else
if {FORMATTEDTRANS.TYPE_72_STATUS} = "DL" then "Image Scanned" else
"test to see if gets here"

 

[crystalreporting]

Try bracketing each 'set' of if statements.

 

[lynchdog]

Thanks for the input but still no dice...I am completely confused by this.


if ({FORMATTEDTRANS.TYPE_69_STATUS} = "MATCH" or
{FORMATTEDTRANS.TYPE_70_STATUS} = "MATCH" or
{FORMATTEDTRANS.TYPE_71_STATUS} = "MATCH&quot then "Image Displayed: Accepted" else
if ({FORMATTEDTRANS.TYPE_69_STATUS} = "NOMATCH" or
{FORMATTEDTRANS.TYPE_70_STATUS} = "NOMATCH" or
{FORMATTEDTRANS.TYPE_71_STATUS} = "NOMATCH" and
{FORMATTEDTRANS.TYPE_72_STATUS} = "DL&quot then "Image Displayed: Re-Scanned" else
if ({FORMATTEDTRANS.TYPE_69_STATUS} = "NOMATCH" or
{FORMATTEDTRANS.TYPE_70_STATUS} = "NOMATCH" or
{FORMATTEDTRANS.TYPE_71_STATUS} = "NOMATCH" and
{FORMATTEDTRANS.TYPE_72_STATUS} = "&quot then "Image Displayed: Not Accepted" else
if ({FORMATTEDTRANS.TYPE_72_STATUS} = "DL&quot then "Image Scanned" else
"test to see if gets here"

 

[dgillz]

Do any of these fields have null values which is tripping up the report?

Go to file, options, convert null field value to default and rerun the report and see what happens. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[lynchdog]

Yes that was the trick...Thanks for the posts/help. I've been confused by this for a day now on other if formulas..

Josh