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

February 22, 2005

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