CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0that fire up the Table, Matrix and Chart wizards, have been added to the body of the report to guide the
designer through the required steps to producing a finished product.
Note Since the Report Builder 2.0 and Report Builder 3.0 reports are not using a Report Model as a data
source, I have installed Report Builder 2.0 on the server containing SQL Server 2012. Being that we have used this
server throughout the text in developing our reports, it contains the full Pro_SSRS database.
By way of example, let’s build a new version of the Employee Service Cost report that you’ve been
seeing throughout this book. If you are using SQL Server 2008 R2 or SQL Server 2012 and using the
Report Builder 2.0 from installing the thick client as I am, you will start Report Builder 2.0 by navigating
to the Microsoft SQL Server 2008 Report Builder 2.0 folder under All Programs of Windows start menu.
Once you have Report Builder 2.0 fired up, you will want to click on the Table or Matrix icon on the
report design surface. As mentioned, this will bring up the New Table or Matrix wizard and begins by
prompting you to select an existing data source or create a new one as shown in Figure 13-45.
Figure 13-45. New Table or Matrix wizard in Report Builder 2.0
Select New... to create a new data source for this report. Name the data source Pro_SSRS and with
the connection type set to Microsoft SQL Server, click on the Build...button to select the server. In this
case, set the server name to localhost, Pro_SSRS as the database name, as in Figure 13-46. Click OK to
save the Connection Properties and then click OK again to save the Data Source Properties. Now that our
data source has been created, click Next to build the query in the query designer window.