• Since you posted this question also in SQL Server newbies under SQL Server 2008, I have a feeling that your question has nothing to do with Reporting Services. Can you write if the question is about the syntax in Reporting Services or is it about the way that the function IIF should be used in SQL Server 2012? Also it would be helpful if you'll post the questions in the correct forums.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/