We "deliver"
our design efforts to the information consumers by publishing the Report
Model Project to a report server. We will publish the components of
our project by taking the following steps.
1.
Ensure
that the Report Server information is properly configured for the
project, by right-clicking the new RS028 Intro Report ModelProject
in Solution Explorer.
2.
Select
Properties from the context menu that appears,as depicted in Illustration
35.
By
default, the Business Intelligence Development Studio general setting is
as shown above, http://localhost/reportserver. Once we have the report
server aligned as we desire, deployment is a simple exercise.
3.
Make
changes as appropriate to the report serverURL within the TargetServerURL
property setting.
4.
Click
OK to accept changes, and to dismiss the Properties page.
5.
Right-click
the RS028 Intro Report Model project in Solution Explorer, once
again.
6.
Click
Deploy from the context menu, as depicted in depicted in Illustration
37.
Illustration 37:
Deploying the Report Model Project to the Designated Report Server ...
The Model Project
uploads successfully to the report server (we can view it via Report
Manager to verify the upload). To make the new model available to our
information consumers, we must provide access via role assignments. We will
take up these steps for using Report Builder, as well as the details of
various in-depth techniques and nuances in Report Model design, in
separate articles within the MSSQL Server
Reporting Services series.
7.
Select
File --> Save All, to save our work to this point, as shown in Illustration
38.
Illustration 38: Ensuring the
Correct Report Server Settings
8.
Select
File --> Exit, to leave the Business Intelligence Development Studio,
when ready.
Conclusion ...
In
this article, we introduced a powerful new "self-serve" reporting
apparatus, the Report Builder. After initially discussing Report
Builder and its features, we shifted to the focus of our hands on practice
session surrounding the design and creation of the Report Model, noting
that we concentrate on the use of the Report Builder from the consumer
perspective in articles where we provide practice within that context. In
gaining hands-on exposure to the creation of a Report Model, we created
a new Report Model Project within the Business Intelligence
Development Studio, and then defined a Data Source containing the
information Report Builder needs to connect to a database. We next
created a Data Source View within our project to contain schema
information upon which we based our next addition, and the centerpiece of our
efforts, the Report Model.
We then defined the Report Model within the Report
Model Project. Once this was completed, we deployed our Report
Model Project as a means of publishing the Report Model to make it
available to our targeted information consumer audience. Throughout the steps
of our practice session, we discussed, at appropriate junctures, various
settings and techniques involved in achieving our objectives.
» 
Comment and Contribute
