This blog explains on the behavioral difference of IIf function between Reporting Services and in Transact SQL.
IIf function was a new addition in SQL Server 2012 which provides a simplified way to implement conditionally logic. Though we have a similar function available in SSRS 2005 onwards there is a small difference in the functionality between IIf function in SSRS and that in T-SQL.
IIf function was a new addition in SQL Server 2012 which provides a simplified way to implement conditionally logic. Though we have a similar function available in SSRS 2005 onwards there is a small difference in the functionality between IIf function in SSRS and that in T-SQL.
I’ve explained this difference in the below MSDN article using few scenarios
Feel free to go through this and let me know your valuable feedback