Pro SQL Server 2012 Reporting Services

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

Figure 13-2. Viewing the new Patient Census report model

Adding a Data Source

Logically, the first step is to create a data source. Before we can create a data source connecting to our

SQL Server 2008 R2 machine, you will need to restore the Pro_SSRS_2008R2 database, as described in the

ReadMe.txt file available in the Source Code/Download area for the book on the Apress Web site

(www.apress.com). After you have the Pro_SSRS_2008R2 database set up, we need to create a data

source for our model. Right-click the Data Sources folder in the Solution Explorer and select New Data

Source under the Add menu. This brings up the Data Source Wizard to create a data source for a report

model. Figure 13-3 shows the first page of the Data Source Wizard. Fortunately, you can select to not

display the first page every time you open the wizard by checking Don’t Show This Page Again.

Figure 13-3. Using the Data Source Wizard