CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0Create a Report Model using BIDS 2008 R2
In this section, you will create a report model project using BIDS 2008 R2. A completed version of this
project is included in the Source Code/Download area for the book on the Apress Web site
(www.apress.com). When you open the solution, you will notice an already created report model called
Patient Census Book. If you would like to publish the Patient Census Book report model as it is in the
project to your SSRS server and begin working with the client-side Report Builder 1.0 application, just be
sure to set the data source settings and deploy appropriately. In that case, just skip to the “Creating
Reports with Report Builder 1.0” section. To follow the steps to create each piece of a report model using
Business Intelligence Development Studio for SQL Server 2008 R2, from adding data sources and data
source views to publishing the completed model, read on.
Open up BIDS on a machine that has BIDS installed for a SQL Server 2008 R2 installation. You will
find BIDS by clicking on the Windows Start button, All Programs, SQL Server 2008 R2, and then SQL
Server Business Intelligence Development Studio. Once BIDS is started, click on Project... next to the
“Create:” label. As you can see in Figure 13-1, you can use several available project templates. Choose
the Report Model Project template, name it Patient Census, add the appropriate location (in this case
C:\Pro_SSRS Project_2008R2), and click OK.
Figure 13-1. Creating a new report model project
A report model project has three main components: data sources, data source views, and report
models, each one relying on the previous one. In other words, a data source view requires a data source,
just as a report model requires a data source view. If you have successfully created the Patient Census
report model project, you will see these three components, as shown in Figure 13-2.