Report Builder is a ClickOnce application that you can launch from SQL Server Report Manager site. It allows you or your clients to easily set up a "User Configurable Report". SQL Server 2005 came with Report Builder 1.0. With SQL Server 2008 you can choose between Report Builder 1.0 or Report Builder 2.0.
One of the limitations of Report Builder 1.0 is that you cannot drag and drop a field read form data base into a text box, you can only do that to a table or matrix. This problem is fixed in Report Builder 2.0 and that was the reason recently we decided to use Report Builder 2.0 in our project.
The other benefits that you get from Report Builder 2.0 compared with Report Builder 1.0 are:
- the look and feel is more like other Microsoft Office 2007 products,
- there is added support for data visualizations including charts and gauges and
- there is a capability to export to Microsoft office Word format.
One other new feature in Report Builder 2.0 is that in addition to being able to run as ClickOnce application from Report Manger, it can also be installed and run as a stand alone application not requiring Report Manager.
You can get Report Builder 2.0 from:
To set Report Builder 2.0 to be the default report builder on Report Manager, after installing SQL Server 2008 you need to also install SQL server 2008 Service Pack 1.0 which is available from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19&displaylang=en. Then follow the instruction at
The full list of comparative features between Report Builder 1.0, Report Builder 2.0 and Report Designer in BIDS (Business Intelligence Development Studio) 2008 is listed in
I have over 17 years of experience in software development in a variety of fields. For last 7 years the emphasis has been mostly on .NET technology (C# and VB.NET) which includes WPF, WCF and ASP.NET AJAX. Also have SQL Server experience including SSIS and SSRS. My blog (http://morrisbahrami.blogspot.com) has a collection of tips and general info for Microsoft Developers.