Reporting Services Report Models - Professional SQL Server 2005 Reporting Services - page 366

Figure 8-32
Summary
In this chapter, you took a look at creating Reporting Services Report Models. You started by creating a
data source within your Report Model project. A data source in a Report Model project can connect to a
SQL database. Other databases are not currently supported.
After you created a data source, you looked at adding a Data Source View. The Data Source View is a
logical representation of the underlying database. It allows you to add a level of abstraction from our
source. You then created named queries to help shield your model from database changes as well as
create diagrams to more easily view certain objects.
Once the Data Source View was in place, you could run the Report Model Wizard. The Report Model
Wizard runs through a number of steps, but the key process is the Model Rules Generation. You saw
what rules are implemented and how they use the underlying Data Source View to create objects.