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

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
Database Tools
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
News Via RSS Feed

follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Mar 21, 2005

MSSQL Server Reporting Services: Black Belt Administration: "Governor" Capabilities: Report Execution Timeout - Page 7

By William Pearson

Deploy the Clone Report for Later Use

Let's deploy the report, publishing it to Report Manager along with its data source, where we will work with it after we examine the process of setting our "global" Report Execution Timeout value in the next section. First, we need to assign deployment properties to our project.

1.  From within the Solution Explorer, right-click the RS015 project we created earlier (not the RS015.rdl file, but the project folder itself).

2.  Select Properties from the context menu that appears, as shown in Illustration 15.

Illustration 15: Selecting Properties from the Context Menu ...

The Property Pages dialog opens, defaulted to the General page, for the RS015 project.

3.  Make the settings, listed in Table 1 below, for General Properties (Deployment):








http://<Server Name>/ReportServer

Table 1: General - Deployment Properties Dialog

NOTE: For TargetServerURL, substitute the appropriate server name for your own Reporting Services environment.

The General Properties page, Deployment properties, appears, using the settings on my server as an example, as depicted in Illustration 16.

Illustration 16: Properties Dialog Box with Settings

4.  Click OK to accept changes and to exit the RS015 Property Pages.

We return to the Report Designer. Let's publish the clone report.

5.  From within the Solution Explorer, right-click the RS015 project (not the RS015.rdl file, but the project folder itself), as before.

6.  Select Deploy from the context menu that appears, as shown in Illustration 17.

Illustration 17: Selecting Deploy from the Context Menu ...

Deployment begins, and completes successfully, as we can note from the Output window in Report Designer (depicted in Illustration 18).

Illustration 18: Successful Deployment Events, as Displayed in the Output Window

NOTE: Any errors in publishing appear in the Task List window in Report Designer.

We will verify the successful publication of the report in the next section, where we move to Report Manager to examine the Report Execution Timeout setting. We have now established a sample report to revisit, once we have looked at Report Execution Timeout settings at a more global level.

7.  Select File --> Save All from the main menu, to protect our work for a visit later.

8.  Select File --> Exit to close the Report Designer and Visual Studio .NET.

MS SQL Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



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