a Copy of the FoodMart Sales Report
As we have noted, we
will be working with a copy of the FoodMart Sales report, to keep the
original sample intact for easy access and use at another time.
the Reports folder underneath the newly created shared data source, in
the Solution Explorer.
-> Add Existing Item from the cascading context menus that appear, as
depicted in Illustration 11.
Existing Item - RS011 dialog appears.
installed Reporting Services, the default installation point for the sample
report files was the Samples folder within the Reporting Services
program folder. A common example of this default path is as follows:
C:\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Reports
Using the Add Existing Item - RS011 dialog, navigate to the location of the sample
reports in your own environment.
An example of the Add
Existing Item - RS011 dialog, having been pointed to the Samples folder (which contains the FoodMart
Sales report we seek), appears as
shown in Illustration
Illustration 12: Navigating
to the Sample Reports Folder ...
the FoodMart Sales report inside the dialog.
from the context menu that appears, as depicted in Illustration 13.
Illustration 13: Performing
a Quick Copy of the FoodMart Sales Report
somewhere in the white space to the right of the report files within the
from the context menu that appears, as shown in Illustration 14.
Illustration 14: Select
Paste to Complete Copying ...
of the FoodMart Sales report appears, with "Copy of" appended
at the front of the name of the file, within the dialog.
the new file.
from the context menu that appears.
following name in place of the highlighted existing name:
Foodmart Sales - Filtered Dataset.rdl
NOTE: Be sure to include the .rdl extension in the file name.
copy of the FoodMart Sales sample report appears as depicted in
Illustration 15: The New Report, FoodMart
Sales - Filtered Dataset.rdl
Select the new
file by clicking it, if necessary.
on the dialog box to add the new report to report project RS011.
Sales - Filtered Dataset.rdl appears in the Reports folder, within the RS011 project tree in the
Solution Explorer, as shown in Illustration 16.
Illustration 16: FoodMart Sales -
Filtered Dataset.rdl Appears in Solution Explorer
created a copy of the functional report, we are now ready to make the
modifications requested by the FoodMart information consumers.