Report Builder Report Samples

With Microsoft SQL Server 2005 Reporting Services, you can build ad hoc reports using Report Builder. Before beginning, you can upload Report Builder report samples to the report server and view them in Report Builder. This sample is not supported on IA64.

The Report Builder sample reports are shipped with SQL Server 2005. The SQL Server samples are not installed automatically during setup. For instructions about how to install the samples, see Installing Samples in SQL Server 2005 Books Online. After you run the samples installation, the samples are located at:

[drive:]\Program Files\Microsoft SQL Server\90\Samples

Scenario

The purpose of these report samples is to show SQL Server Reporting Services Report Builder users how ad hoc reports are created in Report Builder using predefined templates, how they can be modified within Report Builder, and how they are published to the report server.

Languages

Report Definition Language (RDL) and Semantic Model Definition Language (SMDL)

Features

The report samples use the following Reporting Services features.

Prerequisites

Before uploading and working with these samples in Report Builder, make sure that you have:

• Deployed the AdventureWorks report model to the report server that you are using to launch Report Builder.
• Permissions to access the data in the AdventureWorks database.
• Permissions to publish to the report server.

Installing the Report Samples on Your Report Server

The report samples need to be published to the report server where the AdventureWorks report model is deployed. Once the reports are on the report server, you can open the reports in Report Builder.

To publish the report samples

1. Place the sample reports in a network location that is accessible to you.

2. Click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Business Intelligence Development Studio.

3. On the File menu, point to Open, and then click Project/Solution.

4. In the Open Project dialog box, navigate to the location where you placed the sample reports.

5. Select Report Builder Sample Reports.sln, and then click Open.

   The contents of the project are displayed in Solution Explorer. The following reports are listed in the Reports folder: Customer List, Product Sales by Year, and Sales by Territory.

   Note

   These reports cannot be opened directly from the project because they are not bound to the report model until they are published on the report server.

6. On the Build menu, click Deploy Report Builder Sample Reports.

   When the deployment completes successfully, a Deploy succeeded message is displayed at the bottom of the window.

Opening a Report Sample in Report Builder

After you have published the report model to the report server, you can open it in Report Builder.

To open a report sample in Report Builder

1. Open your Web browser and in the address bar type the URL for your report server. By default, the URL is http://<webservername>/reports.

2. Press ENTER.

   Notice that the Report Builder Sample Reports folder appears on the Contents tab.

3. Click Report Builder.

4. In the Getting Started pane, click Open from Report Server.

5. In the Open Report dialog box, select the sample report that you want to open, and then click Open.

   The report is displayed in the design area of the Report Builder window.

See Also

Tasks

Report Model Samples
Installing Samples

Other Resources

Installing AdventureWorks Sample Databases and Samples
Adventure Works Cycles Business Scenarios

Help and Information

Getting SQL Server 2005 Assistance

Change History