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