Hi there. I seem to be running into a great argument at my work, and with some other folks I have run into. From the DBA side, it seems that when creating reports in SSRS 2005/2008 there is the belief that using expressions in the report is a bad idea. 'Do as much as you can in the query' seems to be the mantra. Use when or case instead of IIF. Convert in the query etc.
So my question is, does there exist a best practices guide for SSRS? I always try to use expressions, and find that this lends itself to more report functionality.
What do you think, but more importantly, what do the experts say?