Results 1 to 2 of 2

Thread: [RESOLVED] Nested IF CR 9

  1. #1

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Resolved [RESOLVED] Nested IF CR 9

    Does CR9 permit Nested IF?
    Can somebody correct this....
    Code:
    if {Query2.addressLine1}<>"" then {Query2.addressLine1} & if {Query2.addressLine2}<>"" then chr(10)& chr(13) & {Query2.addressLine2} (if {Query2.addressLine3}<>"" then chr(10)& chr(13) & {Query2.addressLine3} else "" else "" else "";
    Thankz

  2. #2

    Thread Starter
    Frenzied Member
    Join Date
    Aug 2006
    Location
    India, Punjab, Bhatinda
    Posts
    1,689

    Re: Nested IF CR 9

    Strange I posted the solution immediately somehow its missing...
    No problem. This might help somebody
    Code:
    if {Query2.addressType}= "RESIDENCE" then
        if {Query2.addressLine1}<>"" then 
            {Query2.addressLine1} 
            & if {Query2.addressLine2}<>"" then 
                chr(10)& chr(13) & {Query2.addressLine2} 
                & if {Query2.addressLine3}<>"" then 
                    chr(10)& chr(13) & {Query2.addressLine3} 
                else '' 
            else '' 
        else ''
    else 
    ''
    ;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width