Report Builder Report Samples


Updated: 14 April 2006
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.

Note:
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.



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.

Application Area Features
Reporting Services Report Builder
Reporting Services Report Manager


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.

Change History


Release History
5 December 2005 New content: Procedure for publishing report samples. Changed content: Procedure for opening samples.


© 2007 Microsoft Corporation. All rights reserved.

Last edited Nov 6, 2008 at 10:05 PM by bonniefe, version 17

Comments

NINiki Nov 24, 2010 at 9:17 AM 
Unbelievably sloppy. None of the downloads for 2005 are available - all you can ever find is 2008. Even tried following the link given on one of the other pages (http://social.technet.microsoft.com/wiki/contents/articles/ssrs-reporting-services-samples-on-codeplex.aspx) which doesn't exist.
Sloppy sloppy sloppy. I actually have a job to do and wandering round this useless site for hours to try to get these samples is so very very very frustrating. Most of us are still on SQL 2005 (and likely to remain so in current economic climate), so well done for managing to totally alienate us.
Last time I come to codeplex. I guess I just google it with a "-codeplex" VERY poor job guys.

ingmiguelmejia May 22, 2007 at 4:49 PM 
saludos, me gustaria saber si yo puedo colocarle a un reporte la fecha de creacion de dicho reporte en el encabezado.
gracias.