InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 22:36:35 GMT20http://www.sqlservercentral.com/Forums/Topic1403815-391-1.aspxIIF is used in SSRS, while it is not a valid T-SQL construct is is a valid Reporting Services constructTue, 08 Jan 2013 01:04:55 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1403815-391-1.aspxThanks for your help......I got it to work....=IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2 and Fields!KeptAppointments.Value = 1, 1,0)Mon, 07 Jan 2013 14:40:03 GMTGillian_Pappas2002http://www.sqlservercentral.com/Forums/Topic1403815-391-1.aspxIIF() is a microsoft Access construct. That won't work with SQL Server.Look into the CASE statement instead.Mon, 07 Jan 2013 13:43:13 GMTsturnerhttp://www.sqlservercentral.com/Forums/Topic1403815-391-1.aspxThat is the formula that I added to Visual Studio 2008 calculated formula=IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1)Input field Urgency_level can = 1 - 4, and the Field DateDifference can = 0-100, in the above Fx formulain Visual Studio I and trying to get the calculated field NeedUrgentDates to be true, if the urgency_level = 2and the DateDifference is less than or equal to 2.Thanks for your input.Mon, 07 Jan 2013 12:51:08 GMTGillian_Pappas2002http://www.sqlservercentral.com/Forums/Topic1403815-391-1.aspx[quote][b]Gillian_Pappas2002 (1/7/2013)[/b][hr]=IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1)gives me "Error" on output, but there are no error codes. The syntax checks out and the values forfields urgency_level and DateDifference are numeric data.[/quote]obviously it errors with your posted query .. need more info and full query you are trying and I see IIF what is it ? do you mean IFMon, 07 Jan 2013 12:43:04 GMT@SQLFRNDZhttp://www.sqlservercentral.com/Forums/Topic1403815-391-1.aspx=IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1)gives me "Error" on output, but there are no error codes. The syntax checks out and the values forfields urgency_level and DateDifference are numeric data.Mon, 07 Jan 2013 12:33:11 GMTGillian_Pappas2002