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

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 19, 2005

MSSQL Server Reporting Services: Black Belt Components: Ad Hoc Sorting with Parameters - Page 4

By William Pearson

Create a Copy of the Territory Sales Drilldown Report

As we have noted, we will be working with a copy of the Territory Sales Drilldown report, to keep the original sample intact for easy access and use at another time.

1.  Right-click the Reports folder underneath the newly created shared data source, in the Solution Explorer.

2.  Select Add --> Add Existing Item from the cascading context menus that appear, as depicted in Illustration 12.

Illustration 12: Adding the Report to the Project ...

The Add Existing Item - RS016 dialog appears.

When we 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

3.  Using the Add Existing Item - RS016 dialog, navigate to the location of the sample reports in your own environment.

An example of the Add Existing Item - RS016 dialog, having been pointed to the Samples folder (which contains the Territory Sales Drilldown report we seek), appears as shown in Illustration 13.

Illustration 13: Navigating to the Sample Reports Folder ...

4.  Right-click the Territory Sales Drilldown report inside the dialog.

5.  Select Copy from the context menu that appears, as depicted in Illustration 14.

Illustration 14: Performing a Quick Copy of the FoodMart Sales Report

5.  Within the Add Existing Item - RS016 dialog, navigate to the RS016 folder we created earlier.

6.  Right-click somewhere in the white space inside the RS016 folder, within the dialog.

7.  Select Paste from the context menu that appears, as shown in Illustration 15.

Illustration 15: Select Paste to Complete Copying ...

A copy of the Territory Sales Drilldown report appears within the dialog.

8.  Right-click the new file.

9.  Select Rename from the context menu that appears.

10.  Type the following name in place of the highlighted existing name:

AdHocSort_Territory Sales Drilldown.rdl

NOTE: Be sure to include the .rdl extension in the file name.

The renamed copy of the Territory Sales Drilldown sample report appears as depicted in Illustration 16.

Illustration 16: The New Report, AdHocSort_Territory Sales Drilldown.rdl

11.  Select the new file by clicking it, if necessary.

12.  Click Open on the dialog box to add the new report to report project RS016.

AdHocSort_Territory Sales Drilldown.rdl appears in the Reports folder, within the RS016 project tree in the Solution Explorer, as shown in Illustration 17.

Illustration 17: The New Report Appears in Solution Explorer - Report Folder

Having created a copy of the functional report, we are now ready to make the enhancements requested by the AdventureWorks information consumers.

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