SQL Server Advent Calendar 11 – Report Builder v2

  • Article

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.

image

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..

image

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.

Technorati Tags: Reporting services,report builder,SQL Server 2008