I am using SQL Reporting Services 2005 (with Visual Studio). I am connecting to a db2 database via ODBC and am extracting and manipulating data with the creation of the dataset. However, the SQL IIF does not work when quering DB2 Datasource.
Does anybody know the db2 code for an IIF statement
Many Thanks
K