I had this problem myself recently, what i had to do is create some custom code to handle it, I couldn't get the Iif statement to work properly either, here's...

Don't worry figured it out using a bunch of nested SQL statements and mulitiple stored procs for the report. Thanks for trying if you did.