Publish the Report Model Project
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.
that the Report Server information is properly configured for the
project, by right-clicking the new RS028 Intro Report Model Project
in Solution Explorer.
Properties from the context menu that appears, as depicted in Illustration
page appears, with the report server URL specified within the TargetServerURL
property setting, as shown in Illustration 36.
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 server URL 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.
See All Articles by Columnist William E. Pearson, III
Discuss this article in the MSSQL Server 2000 Reporting Services Forum.
MS SQL Archives