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.
» 
Comment and Contribute
