Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    73

    Unanswered: multiple if statements in a formula?

    is there anyway for me to place in more then one if statement in a formula??

    like right now I'll give ya the basics what I have..or is there away to do what I need to??

    here's the line:

    iif(isnull({RECEIVABLE_LINE.CUST_ORDER_ID}),{RECEI VABLE.PREPAY_ORDER_ID},"")

    And what I need to do..is have it so when the second one is null then to place in the field from receivable_line if there's a way to do a second iif statement or just to add this currently to my iif statement that'd be great..I'm still fairly new to Crystal Reports..so not too certian how it works that well.

  2. #2
    Join Date
    Jul 2005
    Posts
    50
    Create two Formulas:

    @Subst_CustOdr_ID
    (will be substitute from PREPAY_ORDER_ID when CUST_ORDER_ID IsNull)

    IF NOT IsNull({tb_RECEIVABLE_LINE.CUST_ORDER_ID}) Then
    {tb_RECEIVABLE_LINE.CUST_ORDER_ID}
    ELSE
    {tb_RECEIVABLE_LINE.PREPAY_ORDER_ID}

    @Subst_PreOdr_ID
    (will be substitute from CUST_ORDER_ID when PREPAY_ORDER_ID IsNull)

    IF NOT IsNull({tb_RECEIVABLE_LINE.PREPAY_ORDER_ID}) Then
    {tb_RECEIVABLE_LINE.PREPAY_ORDER_ID}
    ELSE
    {tb_RECEIVABLE_LINE.CUST_ORDER_ID}

    Substitute the formulas in place of the actual fields on your report.

Posting Permissions

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