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

With our input, the New Data Source page appears as shown in Figure 11.



Figure 11: The New Data Source Page, with Input


16. Click OK to accept the shared data source.

We are returned to the Execution Log Reports page, Folder View, and see our new data source appear on the Contents tab, as depicted in Figure 12.



Figure 12: The Data Source Appears on the Folder View, Contents Tab

Having created a data source, we will now upload the sample Execution Log reports from the Report Manager. We will then marry the reports to the common data source we have created.

 

Procedure

Uploading the Reports

We will perform the upload of the sample Execution Log reports, by taking the following steps within Report Manager:


1. Click Upload File atop the Folder View, Content tab.

The Upload File page appears.

2. Click Browse.

3. Navigate to the location of the sample reports, folder SSP-RS002, which we created and populated in the first part of our practice procedure above.

Folder SSP-RS002 appears in the Choose File dialog, once located, as shown in Figure 13.



Figure 13: The Target Folder Appears in the Choose File Dialog


4. Click the SSP-RS002 folder to open it.

The sample report definition files (.rdl’s) and other object files appear. At this point, we will select the Today’s Reports report definition files.

5. Click the todays reports.rdl file, as depicted in Figure 14.



Figure 14: Selecting the Today’s Reports File from Among the Sample Set


6. Click the Open button on the dialog.

7. Change the default name in the Name box to the following:

Today’s Reports

The todays reports.rdl file, along with modified title, appears in the respective boxes of the Upload File page, as shown in Figure 15.



Figure 15: The Today’s Reports File – Selected for Upload


8. Click OK.

The report file uploads. We can see it appear listed on the Folder view, Content tab, where we saw the new data source appear earlier.

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 |