Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Feb 22, 2005

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

By William Pearson



Hands-On Procedure

Preparation

Creating and Populating a Folder with the Components We Will Need



To prepare for our session with the Execution Log sample reports, we will create a folder to house the reports, along with other objects that we will need to complete our practice exercises. The folder can be created anywhere on the PC that is convenient from a local perspective.



1.  Right-click Start.

2.  Select Explore to launch Windows Explorer.

3.  Navigate to a convenient place to create the folder that will contain the "collateral" for our practice session.

4.  Create a folder named as follows:

RS014

The folder appears similar to that depicted in Illustration 2.




Illustration 2: New Folder in Place to House Lesson Components

5.  Locate the Reporting Services installation CD on an accessible CD drive.

6.  Navigate to the following folder (or it's equivalent, substituting your own CD drive for "F:" below):

F:\extras\Execution Log Sample Reports

The contents of the Execution Log Sample Reports folder appear similar to that shown in Illustration 3.


Illustration 3: The Sample Execution Log Reports Appear

7.  Select Edit --> Select All from the Windows Explorer main menu.

The contents of the Execution Log Sample Reports folder become highlighted.

8.  Select Edit --> Copy from the main menu.

9.  Navigate to the new RS014 folder we created above.

10.  Right-click within the folder.

11.  Select Paste from the context menu that appears, as depicted in Illustration 4.


Illustration 4: Select Paste to Place the Sample File Copies

The copied files (there should be eleven) appear as shown in Illustration 5.


Illustration 5: The Sample Report Files Appear

Our next step will be to upload the samples into Report Manager, where we can review them and see what information they can deliver to the information consumers. The first step of this process will be to establish a Data Source Connection, as we learned in my Database Journal article Managing Reporting Services: Data Connections and Uploads. We will use Report Manager, versus the Report Designer interface, for this purpose, but keep in mind that the upload / publication process can also be managed from within Report Designer.



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date