Click here to Skip to main content
Click here to Skip to main content

Tagged as

Go to top

Report Builder 2.0

, 13 Apr 2011
Rate this:
Please Sign up or sign in to vote.
CodeProjectReport 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 R

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:
http://www.microsoft.com/downloads/details.aspx?FamilyID=9f783224-9871-4eea-b1d5-f3140a253db6&displaylang=en

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
http://technet.microsoft.com/en-us/library/dd795295.aspx

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
http://www.microsoft.com/sqlserver/2008/en/us/report-builder.aspx

License

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

Share

About the Author

Morris Bahrami
Architect
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 (http://morrisbahrami.blogspot.com) has a collection of tips and general info for Microsoft Developers.

Comments and Discussions

 
-- There are no messages in this forum --
| Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 13 Apr 2011
Article Copyright 2011 by Morris Bahrami
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid