Populating a Folder with the Components We Will Need
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.
to launch Windows Explorer.
Navigate to a
convenient place to create the folder that will contain the "collateral"
for our practice session.
folder named as follows:
folder appears similar to that depicted in Illustration 2.
Illustration 2: New
Folder in Place to House Lesson Components
Reporting Services installation CD on an accessible CD drive.
the following folder (or it's equivalent, substituting your own CD drive for "F:"
F:\extras\Execution Log Sample Reports
of the Execution Log Sample Reports folder appear similar to that shown
in Illustration 3.
Illustration 3: The
Sample Execution Log Reports Appear
--> Select All from the Windows Explorer
contents of the Execution Log Sample Reports folder become highlighted.
--> Copy from the main menu.
the new RS014 folder we created above.
from the context menu that appears, as depicted in Illustration 4.
Illustration 4: Select
Paste to Place the Sample File Copies
copied files (there should be eleven) appear as shown in Illustration 5.
Illustration 5: The
Sample Report Files Appear
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