Click here to Skip to main content
12,953,743 members (53,556 online)
Click here to Skip to main content
Add your own
alternative version

Tagged as


Posted 13 Apr 2011

Report Builder 2.0

, 13 Apr 2011 CPOL
Rate this:
Please Sign up or sign in to vote.
Report Builder 2.0

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

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 here. Then follow the instructions here.

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


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Morris Bahrami
Australia Australia
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 ( has a collection of tips and general info for Microsoft Developers.

You may also be interested in...

Comments and Discussions

-- There are no messages in this forum --
Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170525.1 | Last Updated 13 Apr 2011
Article Copyright 2011 by Morris Bahrami
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid