Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Use of IIF function in Crystal Reports Expand / Collapse
Author
Message
Posted Monday, October 29, 2012 11:39 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 6:57 AM
Points: 13, Visits: 25
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
Post #1378570
Posted Tuesday, October 30, 2012 12:36 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 21, 2014 9:37 AM
Points: 26, Visits: 105
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.
Post #1378584
Posted Tuesday, October 30, 2012 12:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 8, 2014 6:57 AM
Points: 13, Visits: 25
Hi,
so,its like a Ternary operator in Java?

Post #1378586
Posted Tuesday, October 30, 2012 2:55 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 11, 2014 9:19 PM
Points: 1,129, Visits: 1,164
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
Post #1378617
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse