Pro SQL Server 2012 Reporting Services

(sharon) #1

CHAPTER 13  CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0


Figure 13-44. Report Builder 2.0’s new interface

 Note In order to use Report Builder 2.0 on a SQL Server 2008 R2 or SQL Server 2012 box, you will need to
install the Report Builder 2.0 thick client. This client can be downloaded from http://www.microsoft.com/en-
us/download/details.aspx?id=24085. If you are using a SQL Server 2008 SP1 box, you can use the ClickOnce
application from the Report Builder button on the Report Manager or from within SharePoint. By default, Report
Builder 1.0 is configured within the Report Manager, so you will need to change the Report Builder URL on the Site
Settings page to reflect your installation folder. For example, if I had SQL Server 2008 SP1 installed, I would
change mine to be /ReportBuilder/reportbuilder_2_0_0_0.application or the full URL of
http://ServerName:PortNumber/ReportServer/ReportBuilder/reportbuilder_2_0_0_0.application.
When in SharePointIntegrated mode, you change the Custom Report Builder URL to be a slightly different URL of
/_vti_bin/ReportBuilder/ReportBuilder_2_0_0_0.application.

As you might imagine, developing a report in Report Builder 2.0 is simplified, with all design choices
available in one of three tabs, Home, Insert, and View. Built-in fields, parameters, images, and data
sources are all contained in folders within the Data window. Like in SQL Server Data Tools (SSDT), Row
Groups and Column Groups areas located are on the bottom. Instructional text, as well as link buttons
Free download pdf