Systems Engineering and RDBMS

New version of Report Builder in SQL Server 2008

Posted by decipherinfosys on February 20, 2009

There is a new version of Report Builder available in SQL Server 2008.  It is not available in the install media but is instead available in the feature pack of SQL Server 2008.  You can download it from here.  As you already know, the previous version of report builder was installed with SQL Server 2005 and when you launched the Report Manager, assuming you have the proper rights in place (need to be a member of the Report Builder role in SSRS), you will see the Report Builder button:

rb2_1And this is still present in SQL Server 2008.  In SQL Server 2008 though, using Report Builder 2.0, you can have a local client install rather than an application that you download and install from the Report Manager.  In addition, Report Builder 2.0 has the look and feel of Office 2007 which the business analyst folks find to be very pleasing (BA’s were in-charge of developing some of the reports at one of our clients – a whole different topic for another day), we can also run reports locally or can run them on the server and in addition to all this goodness, we do not need a report model – we can write up our queries (query designer is still there) and there is a tablix report type as well.

Now, the install of Report Builder 2.0 is pretty straight forward and after the install, you can access it from the main menu using the path shown in the image below:

rb2_2

After you launch it, you will see this interface which has the Office 2007 ribbon interface at the top with the Home, Insert and the View tabs:

rb2_3

And the left pane is for the report parameters, built-in fields and data fields.  The center portion is for the report design and the two bottom sections – row groups and column groups allow you to setup groupings using a drag and drop interface.

In the next post, we will show how easy it is to create reports using the new Report Builder.

One Response to “New version of Report Builder in SQL Server 2008”

  1. […] New version of Report Builder in SQL Server 2008 […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: