Question Re: Nested if else statement crystal report in Technology Q&A

Nested if else statement crystal report

Former Member — Thu, 02 Apr 2020 21:59:23 GMT

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}

Re: Nested if else statement crystal report

jerryjanda — Thu, 02 Apr 2020 22:03:12 GMT

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

Re: Nested if else statement crystal report

DellSC — Thu, 02 Apr 2020 22:26:31 GMT

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

-Dell

Re: Nested if else statement crystal report

vitaly_izmaylov — Thu, 02 Apr 2020 22:35:00 GMT

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"

Re: Nested if else statement crystal report

venkateswaran_k — Fri, 03 Apr 2020 05:43:05 GMT

You can do in another way, useing IIF statement

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

Re: Nested if else statement crystal report

Former Member — Fri, 03 Apr 2020 07:21:16 GMT

Thank you very much!!

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

Re: Nested if else statement crystal report

Former Member — Fri, 03 Apr 2020 07:21:35 GMT

Thank you,

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