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 SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


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

Featured Database Articles

MS SQL

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):

Property

Setting

OverWriteDataSources

True

TargetFolder

RS015

TargetServerURL

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


















Thanks for your registration, follow us on our social networks to keep up-to-date