This project is read-only.

Report Builder 1.0 Report Samples

11/05/2008 21:36:06

With Microsoft SQL Server Reporting Services, you can build ad hoc reports using Report Builder. Before starting, you can upload Report Builder report samples to the report server and view them in Report Builder. This sample is not supported on Itanium-based operating systems.

SQL Server samples and sample databases must be downloaded and installed before you can view or work with them. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

Business Intelligence (BI) Development Studio is not supported on Itanium-based computers. However, support for BI Development Studio is available for x64-based computers. If the SQL Server sample databases have been deployed on an Itanium-based computer, use BI Development Studio on either an x86-based or x64-based computer to modify and run the samples.

After you run the samples installation, the samples are located at:
_drive_:\Program Files\Microsoft SQL Server\100\Samples


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.


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


The report samples use the following Reporting Services features.

Application Area Features
Reporting Services Report Builder
Reporting Services Report Manager


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 2008, 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

Report Model Samples Considerations for Installing SQL Server Samples and Sample Databases
Other Resources
Adventure Works Cycles Business Scenarios
Help and Information
  • Getting SQL Server 2008 Assistance* © 2008 Microsoft Corporation. All rights reserved.

Last edited Nov 6, 2008 at 11:05 PM by bonniefe, version 9


No comments yet.