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 5

By William Pearson


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.

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

Folder RS014 appears in the Choose File dialog, once located, as shown in Illustration 13.

Click for larger image

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

3.  Click the RS014 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.

4.  Click the todays reports.rdl file, as depicted in Illustration 14.

Illustration 14: Selecting the Today's Reports File from among the Sample Set

5.  Click the Open button on the dialog.

6.  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 Illustration 15.

Illustration 15: The Today's Reports File - Selected for Upload

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

8.  Repeat steps 1 through 7 above, for each of the following files in the RS014 folder (giving each a logical name within the respective Name box), from which we uploaded todays reports.rdl:

  • longest running reports.rdl
  • report parameters.rdl
  • reportsbymonth.rdl
  • reportsbyuser.rdl
  • reportsexecutedbyday.rdl
  • reportsize.rdl
  • reportsuccessrate.rdl

Once we have uploaded the individual reports, we can see them appear listed on the Execution Log Reports page, Folder View, Content tab, as depicted in Illustration 16.

Illustration 16: The Execution Log Reports Appear in the Folder View - Content Tab

Having uploaded the seven reports listed above, we can click on each to ascertain that the report is executing properly. Should any connectivity issues emerge, see Testing the Reports - and Resolving Data Source Issues in my article Managing Reporting Services: Data Connections and Uploads, as well as the Books Online, for guidance.

9.  Open each report, executing it to overview the data it presents and other features.

We now have a working data source, as well as a group of sample reports that not only provide a "quick start" for the information consumers' performance and auditing reporting efforts, but which also act as a good set of reports to follow when constructing new reports along the same lines. We will create a custom report next, to obtain a little more familiarity with the source data, as well as with a representative report's layout and other characteristics.

10.  Close the browser, when finished exploring the various reports.

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