Nested if else statement crystal report

[Former Member]

Hi,

I'm quite new to Crystal Reports and I'm stuck, hoping someone here can help me.

I have a report that where I want to print the address to where we shipped our orders. I have four different fields where there can be information about shipping address.

ordlevadr2 (first prio) - if there is data in this field always use that one

ftgpostadr5 (second prio) - if ordlevadr2 is empty look if there is any value here, use this one

ftgpostadr2 (third prio) - if ordlevard2 and ftgpostadr5 is empty and there is a value in this field, use this one

ftgpostadr4 (last prio) - if ordlevadr2, ftgpostadr5 and ftgpostadr2 is empty use this one

if all of the fields are empty set text 'none'

I have tried with below code, but I can't get it right

if ISNULL({q_import_tableu;1.ordlevadr2}) then ( if ISNULL({q_import_tableu;1.ftgpostadr2}) then {q_import_tableu;1.ftgpostadr5} else if ISNULL({q_import_tableu;1.ftgpostadr5}) then {q_import_tableu;1.ftgpostadr2} else if ISNULL({q_import_tableu;1.ftgpostadr4}) then {q_import_tableu;1.ftgpostadr5} else 'none'; ) else {q_import_tableu;1.ordlevadr2}+' '+{q_import_tableu;1.ordlevadr3}

[jerryjanda]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment). While editing, you can also use the "insert code" button to make this portion of the question easier to read. You'll find that button in the question toolbar -- last selection on the right.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Kind regards,

--Jerry

[DellSC]

What is not working right? Are you getting an error?

-Dell

[vitaly_izmaylov · Accepted solution]

Try:

if not (ISNULL({q_import_tableu;1.ordlevadr2}) or ({q_import_tableu;1.ordlevadr2}="")

then

{q_import_tableu;1.ordlevadr2}

else

if not (ISNULL({q_import_tableu;1.ftgpostadr5}) or ({q_import_tableu;1.ftgpostadr5}="")

then

{q_import_tableu;1.ftgpostadr5}

else

if not (ISNULL({q_import_tableu;1.ftgpostadr2}) or ({q_import_tableu;1.ftgpostadr2}="")

then

q_import_tableu;1.ftgpostadr2}

else

if not (ISNULL({q_import_tableu;1.ftgpostadr4}) or ({q_import_tableu;1.ftgpostadr4}="")

then

{q_import_tableu;1.ftgpostadr4}

else "none"

[Former Member · Accepted solution]

Thank you very much!!

It's working and I get the correct addresses that I want in the field 🙂

[venkateswaran_k]

Hi

You can do in another way, useing IIF statement

IIF ( conditon1 ," " ,  
      condition2, " " ,
      condition3 , '' , 
      condition4 , "", 
      condition5 , "" , nonevalue) ).

[Former Member]

Thank you,

I'll try this one as well. Always good to learn multiple ways to solve a problem! 🙂