Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 17, 2006

Report Builder: Creating a Report Model - Page 6

By William Pearson

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.

Click for larger image

Illustration 35: Ensuring the Correct Report Server Settings ...

The Properties page appears, with the report server URL specified within the TargetServerURL property setting, as shown in Illustration 36.

Click for larger image

Illustration 36: The Target Server URL Specification ...

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.

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.

» See All Articles by Columnist William E. Pearson, III

Discuss this article in the MSSQL Server 2000 Reporting Services Forum.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM