Sunday, January 17, 2010

New Data Visualization options in Report Builder 3.0

In my book 'Learning SQL Server Reporting Services 2008' I dealt mostly with reports that can be authored using Report Buidler 2.0.

A complete chapter from the book on Report Builder 2.0 is freely available at the two following links:

Learning SQL Server Reporting Services 2009 - Part 1
Learning SQL Server Reporting Services 2009 - Part 2

Together with SQL Server 2008 R2 Nov-CTP Microsoft released a new Report Builder, Microsoft SQL Server 2008 R2 November CTP Report Builder 3.0 which is available as a standalone download from this location.
It can be installed using either wizards or from the commandline. You could also choose to configure it to work with a report server in native mode, or with a report server running in integrated Sharepoint mode.

I took a first look at it installing in native mode to my SQL Server 2008 R2 NoV-CTP Hodentek3\Kumori. When I open the Report Builder 3's UI, I see a number of data visualization options that were not available in Report Builder 2.0.

Here is a screen shot of the UI with the new items. In addition to Charts and Gauges, there are several other interesting options.

No comments: Protection Status