IIf function 1

[mmt4331]

Can someone give me an example of the IIf function? How different is it from the If-then-else formula?


bigfuzzydog

 

[Ngolem]

it is basically a choice of actions


IFF({table.value} > 5,"return if true","return if false&quot

 

[DjangMan]

Someone correct me if I'm wrong but IIF usually processes the entire statement where as an If statement will stop processing once it reaches a True condition. Someone came up with a need for that - but I can't come up with an example.

DjangMan

 

[kenhamady]

If you are using the IsNull function to put in a default value for Nulls, you should use the If-Then-Else:

If IsNull({Customer.Postal Code})
then "ERROR"
else {Customer.Postal Code}

This will not work with IIF, because it chokes on the null value:

IIF(IsNull({Customer.Postal Code}),"ERROR",{Customer.Postal Code})

Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[losthorizon]

Here's what Crystal says: "Typical uses:
IIF can be used as an alternative to the If/Then/Else control structure in some situations.
One situation where IIF may be better than a control structure is when writing record selection formulas so that they can be pushed down to the database server. See Switch (expr1, value1, expr2, value2, ..., exprN, valueN) for an example of the techniques involved."