Optimizing Microsoft SQL Server 2000 Reporting Services: Performance and Access Reports from the Execution Log

5. Navigate to the executionlog.rptproj file, which we copied into the SSP-RS002 folder we created earlier, as shown in Figure 19.



Figure 19: Navigate to the Execution Log Sample Reports Project File


6. Click the executionlog.rptproj file to select it.

7. Click Open to open the project file. 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 Figure 20.



Figure 20: Select Add —> Add Existing Item in Solution Explorer (Partial View)


The Add Existing Items dialog appears.

10. Navigate the SSP-RS002 folder.

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

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



Figure 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 Figure 22.



Figure 22: Select Paste to Place the Report File Copy


A file entitled 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 Figure 23.




Figure 23: Select Rename from the Context Menu …

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

Custom_Todays_Reports.rdl

 

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 partially depicted in Figure 24.




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

Continues…



Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |