I just finished watching an online demo of a great new Reporting Services report designer called "Radius". It's a new report designer created by the folks at 90 Degree Software, and I think it’s going to be a home run.
It has a number of things going for it when compared to BIDS and/or Report Builder to design a report:
This sucker really hits a sweet spot between developers (Report Designer) and normal users (Report Builder). You can give it to a user with a basic understanding of databases and relationships, and they can generate a much more complex and eye-pleasing report than they could in Report Builder. However, they still don't have to be a "developer" and understand expressions, etc.
Try it out!