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 Mar 21, 2005

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

By William Pearson

Add the Sample Report to the Project

We can add our clone report file, RS015.rdl, to the project, in a series of steps that closely mirror those with which we added the data source above.

1.  From within the Solution Explorer, right-click the Reports folder that appears within the new RS015 project.

2.  Select Add on the context menu that appears.

3.  Select Add Existing Item from the cascading menu that appears next, as shown in Illustration 11.

Illustration 11: Select Add --> Add Existing Item

The Add Existing Item - RS015 dialog appears.

4.  Navigate to the location of the RS015.rdl report file created earlier.

5.  Select the Report File in the dialog.

The Add Existing Item - RS015 dialog, with the targeted file, appears as depicted in Illustration 12.

Illustration 12: Add Existing Item - RS015 Dialog

6.  Click Open (or double-click the selection) to close the dialog.

Report File RS015 appears in the Reports folder of the RS015 project. Let's test it for data source connectivity.

7.  Right-click RS015.rdl in the Reports folder.

8.  Select Open, as shown in Illustration 13, from the context menu that appears.

Illustration 13: Select Open from the Context Menu ...

Report RS015 opens and appears on the Layout tab of the Report Designer, as depicted in Illustration 14.

Illustration 14: RS015 Appears in Report Designer - Layout Tab (Partial View)

9.  Click the Preview tab to execute the report.

RS015 executes briefly, and then returns data, based upon the default parameters provided atop the report. We can thus rely upon the fact that we have established connectivity with the data in the AdventureWorks2000 database. (We will not be working with drillthrough and other functions within this report sample at present. The report is only here as an example for limited use in the final section of our practice session.)

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