Publish the Report Model Project
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 Model Project in Solution Explorer.
2. Select Properties from the context menu that appears, as depicted in Illustration 35.
The Properties page appears, with the report server URL specified within the TargetServerURL property setting, as shown in Illustration 36.
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 server URL 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.
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.
» See All Articles by Columnist William E. Pearson, III
Discuss this article in the MSSQL Server 2000 Reporting Services Forum.