Home Forums SQL Server 2008 SQL Server 2008 - General =IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1) Errors, but does not give me an error code RE: =IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1) Errors, but does not give me an error code
Ant-Green
SSC Guru
Points: 113445
More actions
January 8, 2013 at 1:04 am
#1574645
IIF is used in SSRS, while it is not a valid T-SQL construct is is a valid Reporting Services construct