A really cool tool out of MS SQL 2008 that didn’t get released is Report Designer, even with some of the Analysis Services limitations it has. Even though it isn’t released yet, you can still get it.
The good news is that you can now download the RC1 version here. The really good news is that it has got some wizards and loads of other stuff in it to make using it a lot more friendly. It’s also a standalone .msi which you can then deploy to your users as needed, although I believe it will eventually be a click once application like Report Builder v1 in SQL Server 2005.
I will be having a play with over the next few days and I will be sharing that in a future post.