a Clone Report to Parameterize
copy an existing report to provide a disposable work environment. When we
installed Reporting Services, the sample report files were copied to the PC,
with the default installation point being the Samples folder within the
Reporting Services program folder. A common example of this default path is as
C:\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Reports
the FoodMart Sales.rdl file.
from the context menu that appears, as shown in Illustration 1.
Illustration 1: Select
Copy from the Context Menu
Navigate to a
convenient location to place the copy.
within the folder chosen.
from the context menu that appears, as shown in Illustration 2.
Illustration 2: Select
Paste from the Context Menu
The FoodMart Sales.rdl file appears in the new location.
the file once again.
from the context menu that appears, as shown in Illustration 3.
Illustration 3: Select Rename
from the Context Menu
file as follows:
We now have a
disposable report that we can use in Report Designer without fear of
damaging a potentially useful sample. Next, we will create a project in
Visual Studio, from which to work, and then open the report and remove the
existing basic prompt to generate a consolidated product sales report for the
Create the Report Project
begin, we will launch Reporting Services' Report Designer, found in Microsoft
Visual Studio .NET 2003.
the Microsoft Visual Studio .NET 2003 in the Programs group, as
equivalent on my PC appears as shown in Illustration 4.
Beginning in Microsoft Visual Studio .NET 2003 ...
--> New from the main menu.
from the cascading menu, as shown in Illustration 5.
Selecting a New Project
Project dialog appears. We note that Business Intelligence Projects
appears in the Project Types tree, indicating an installation of Reporting
Services (the folder was added by the installation of Reporting Services,
as it established the Report Designer in Visual Studio .NET).
Click Business Intelligence Projects in the Project Types tree, if necessary.
Project in the Templates list.
Navigate to a
location in which to place the Report Project files.
following into the Name box, leaving other settings at default:
The New Project
dialog appears, with our addition, as shown in Illustration 6.
Illustration 6: The New
Projects Dialog, with Addition
new project appears in the Solution Explorer (upper right corner
of the Visual Studio .NET interface), as we see in Illustration 7.
Illustration 7: The New
Project Appears in the Solution Explorer
have now created a Report Project, and are ready to proceed with opening
the new clone Report File.