Illustration 36: The
Target Server URL Specification ...
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.
changes as appropriate to the report serverURL within the TargetServerURL
OK to accept changes, and to dismiss the Properties page.
the RS028 Intro Report Model project in Solution Explorer, once
Deploy from the context menu, as depicted in depicted in Illustration
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.
File --> Save All, to save our work to this point, as shown in Illustration
Illustration 38: Ensuring the
Correct Report Server Settings
File --> Exit, to leave the Business Intelligence Development Studio,
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.