similar function in Ireport like IIF in Crystal Reports

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » similar function in Ireport like IIF in...

similar function in Ireport like IIF in Crystal Reports

Rate Topic

Display Mode

Topic Options

Author

Message

anandhaksc

Posted Tuesday, October 30, 2012 3:33 AM

Grasshopper

Group: General Forum Members
Last Login: Sunday, May 19, 2013 10:28 PM
Points: 12, Visits: 18

Dear All,
Any function available in Ireport which has same functionality like Crystal Reports IIF Function.If its so then tell me with some simple example . Please help me and thanks in advance..

Regards,
T.Anandhaksc

Post #1378637

derek.colley

Posted Tuesday, October 30, 2012 4:15 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 8:19 AM
Points: 496, Visits: 584

IF vs IIF: IF is a logical operator - IF a THEN b ELSE c. Whereas IIF is a construct, meaning 'IF and ONLY IF' and the SQL syntax differs - IIF (a, b, c) - which will execute b on TRUE and c on FALSE.

In terms of reporting, I would steer clear of IIF and go for IF with a code block for connected statements to execute when evaluated to true to avoid ambiguity and allow for multiple statements e.g.

IF @a = True
  BEGIN
    -- do something
    -- do something else
  END
ELSE
  BEGIN
    -- do something
    -- do something else
  END

Rather than:

IIF (@a = True, do something, do something)

There's an interesting discussion on the mathematical differences of IF and IIF over on Wikipedia (link below), and how the English term of IF and ONLY IF is actually wrong (should be ONLY IF and IF).

Links below.

IIF: http://msdn.microsoft.com/en-us/library/hh213574.aspx
IF.. ELSE: http://msdn.microsoft.com/en-us/library/ms182717.aspx
Wikipedia: http://en.wikipedia.org/wiki/If_and_only_if

---

Note to developers:
CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
So why complicate your code AND MAKE MY JOB HARDER??! Crazy

Want to get the best help? Click here http://www.sqlservercentral.com/articles/Best+Practices/61537/ (Jeff Moden)
My blog: http://uksqldba.blogspot.com
Visit http://www.DerekColley.co.uk to find out more about me.

Post #1378654

« Prev Topic | Next Topic »

Permissions