SQLServerCentral / Reporting Services / Reporting Services / IF/ELSE/THEN FUNCTION IS SSRS 2008 R2 / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 12:21:44 GMT20RE: IF/ELSE/THEN FUNCTION IS SSRS 2008 R2http://www.sqlservercentral.com/Forums/Topic1409424-150-1.aspxThank You very much it is working fineMon, 21 Jan 2013 10:17:55 GMTskgudi2009RE: IF/ELSE/THEN FUNCTION IS SSRS 2008 R2http://www.sqlservercentral.com/Forums/Topic1409424-150-1.aspx=IIF(Reportname.Fieldname="yes",reportname.Amount1,reportname.amount2)Mon, 21 Jan 2013 04:18:45 GMTabdulkalam.mRE: IF/ELSE/THEN FUNCTION IS SSRS 2008 R2http://www.sqlservercentral.com/Forums/Topic1409424-150-1.aspxYou need to use the IIF function.[url=http://msdn.microsoft.com/en-us/library/ms157328.aspx]Expression Examples (Report Builder and SSRS)[/url]Mon, 21 Jan 2013 02:26:59 GMTKoen VerbeeckIF/ELSE/THEN FUNCTION IS SSRS 2008 R2http://www.sqlservercentral.com/Forums/Topic1409424-150-1.aspxHow to add this Function in SSRS 2008 R2if {Reportname.Fieldname}='yes' then{reportname.Amount1} else {reportname.amount2}This is added in Crystal Report but i wan to add this in ssrs 2008r2 please help meMon, 21 Jan 2013 02:06:58 GMTskgudi2009