Day 11 of my virtual advent calendar, about stuff I like in SQL Server 2008..
…and I mentioned redesigning charts in my last post and the best answer might be to get your users to do it for themselves in Report Builder 2.
Leaving you (the DBA BI expert) to concentrate on getting them the data they need. Report Builder2 is built of the same code as the Report designer in BI development studio, but has a different query builder. If you want to use a report model then the model needs to be deployed to report manager and then report builder can see it from the data source dialog..
Report Builder v1 is still available as a ClickOnce deployment from Report Manager in SQL Server 2008, but if you want Report Builder 2 it needs to be downloaded from the Feature pack here.