Pro SQL Server 2012 Reporting Services

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

grouping, and sorting capabilities. The goal in this section is to show you how to create and deploy, step

by step, the requested census reports from the Patient Census model created earlier in this chapter.

When Reporting Services is installed for SQL Server 2008 R2, the default Report Builder application

is 3.0. If you are following along or you want to create reports using Report Builder 1.0, you will either

need to navigate directly to the Report Builder URL or change the default Custom Report Builder launch

URL in the Site Settings section of the Report Manager. You can find the report builder application under

the Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting

Services\ReportServer\ReportBuilder folder. To follow along, we are going to set the launch URL in the

Report Manager to use Report Builder 1.0. To do this, open up Report Manager by navigating to

http://ServerName/Reports. Once Report Manager is open, click on the Site Settings link in the top

right corner. Set the launch URL to:

http://localhost/ReportServer/ReportBuilder/ReportBuilder.application

After you change the default Report Builder URL, now let’s use it. Click Apply to save your changes

and navigate to the Report Manager home page. Once on the home page, you should see the Report

Builder icon on the main toolbar of the Report Manager as shown in Figure 13-20. Click the Report

Builder button to initialize the Report Builder 1.0 installation if it is not already installed or to open the

installed application.

Figure 13-20. Report Manager main toolbar with Report Builder button

 Note As we stated previously, it is also possible to launch Report Builder 1.0 directly from the ReportServer URL such as

https://mySSRSserver/ReportServer/ReportBuilder/ReportBuilder.application.

Report Builder 1.0 uses ClickOnce technology to install itself from the Web site. The code is

downloaded and installed to the local machine from the browser, assuming there are no issues with

missing prerequisites, one of which is .NET Framework 2.0. If this is not installed, it will issue a warning

message that Report Builder 1.0 requires .NET Framework 2.0 before it can be installed. If all the