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.
Are there any plans to make the version 2 the click once application from Sql Server 2008? If so, any idea on the time frame?
I believe it was going to be, let me check and get back to you
This was also a concern I had. I noticed on an MS Forum (http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/2116b6b4-3e26-41d4-916e-337a91cee9a3/) that it's planned for either a cumulative update or SP1. Report builder came out just after the initial release of SQL Server 2008, so that's probably why it doesn't link to RB2.. could have been an oversight when RB2 was released that an update to report manager was also needed.. or it could have been deliberate (but annoying!)
ps - andrew - this advent calendar blog this is great, esp to a newbie on SQL Server 08.
Thanks Richard, hopefully you have a real calendar to opne as well!