Post reply

Use of IIF function in Crystal Reports

  • October 29, 2012 at 11:39 pm

    #264087

    Dear All,

    I wish to know the use of IIF function in Crystal Reports with some example .please anyone help me.Thanks in advance..

    Regards,

    T.AnandhaMurugan

  • October 30, 2012 at 12:36 am

    #1554009

    The IIF statement is the same as an IF statement. The first parameter is the conditional statement. The second parameter is the return value if the condition is met. The third parameter is the value returned if the condition is not met.

    The IIF statement has many uses.

    - To show or hide data based on a condition.

    - To show a default value if a field is null or empty.

    - It can be used in a formula to give every other row a background color.

    - etc.

    Mickey Stuewe
    Sr Database Developer
    My blog
    Follow me on twitter: @SQLMickey
    Connect with me on LinkedIn
    --------------------------------------------------------------------------
    I laugh loudly and I laugh often. Just ask anyone who knows me.

  • October 30, 2012 at 12:56 am

    #1554010

    Hi,

    so,its like a Ternary operator in Java?

  • October 30, 2012 at 2:55 am

    #1554040

    anandhaksc (10/30/2012)

    Hi,

    so,its like a Ternary operator in Java?

    yes like ternary operator..

    .or conditional operator in C (if i remember correctly that's what it called)...

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply