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 Feb 22, 2005

MSSQL Server Reporting Services : Black Belt Administration: Execution Log Performance and Audit Reports - Page 7

By William Pearson

The project file opens. Let's make a quick clone of the report file we want to modify, so as to keep the other samples intact for now. (I like to keep a "pristine set" around for just such situations as this).

8.  In the Solution Explorer, right-click the Reports folder.

9.  Select Add --> Add Existing Item from the cascading menus, as depicted in Illustration 20.

Click for larger image

Illustration 20: Select Add --> Add Existing Item in Solution Explorer (Partial View)

The Add Existing Items dialog appears.

10.  Navigate to the RS014 folder.

11.  Right-click the todays reports.rdl file, within the RS014 folder.

12.  Select Copy from the context menu that appears, as shown in Illustration 21.

Illustration 21: Copy the File in the Add Existing Item Dialog (Partial View) ...

13.  Right-click in the white space to the right of the files in the same dialog.

14.  Select Paste from the context menu that appears, as depicted in Illustration 22.

Illustration 22: Select Paste to Place the Report File Copy ...

A report titled Copy of todays reports.rdl appears in the folder.

15.  Right-click in the Copy of todays reports.rdl file.

16.  Select Rename from the context menu that appears, as shown in Illustration 23.

Illustration 23: Select Rename from the Context Menu ...

17.  Type the following into the write-enabled file title:


18.  Click outside the title to accept the modification / close the Edit capability.

The renamed report file clone, Custom_Todays_Reports.rdl, appears in the Add Existing Item Dialog, as depicted in Illustration 24.

Illustration 24: The Report Clone Appears (Circled) in the Dialog

19.  Double-click Custom_Todays_Reports.rdl to select and add it to the project.

The report file appears in the Solution Explorer, as shown in Illustration 25.

Illustration 25: The Report Clone Appears (Circled) in the Solution Explorer

20.  Double-click Custom_Todays_Reports.rdl in the Solution Explorer to open it in Layout view.

The report file opens, and appears on the Layout tab, as depicted in Illustration 26.

Illustration 26: The Report File Opens in Layout View

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