Report Builder 3.0 Stand-alone Sample Reports

5/28/2010


The Report Builder 3.0 stand-alone sample reports are a suite of reports that demonstrate the use of data regions such as table, matrix, and list; data visualization such as charts, sparklines and indicators; and other feature new in SQL Server 2008 R2 Reporting Services such as text rotated 270 degrees. The report data is based on Contoso retail dataset. The report queries include the data and have no dependencies on external data sources.
For step-by-step instructions on how to build reports that are very similar to these, see Tutorials (Report Builder 3.0).

Note:
If you are using SQL Server 2008 Express with Advanced Services, or if you are publishing reports to a SharePoint site that is integrated with a report server, you must modify the report server URL before publishing the sample reports to the report server.


Features

The Report Builder 3.0 sample reports demonstrate a wide range of report features. The following table provides descriptions that explain which features are implemented in each report.

Report Description
FreeFormReport A free form report that resembles a newsletter. The report groups information by territory and displays the name of the sales manager for the territory as well as detailed and summary sales information. The report uses the list data region as the foundation for the report. The report also includes a decorative panel with an image, static text with data inserted, a table to show detailed information, and pie and column charts to display summary information..
MatrixWithSparkline A report that shows data in a matrix. The data is grouped by product names and sales dates. A sparkline depicts sales by date.
Product Sales A report that shows data in a table. The data is grouped by sales date and then subcategory. Indicators depict the state of sales for each subcategory. Report pages contain page and total page number.
SalesByTerritorySubcategory A report that shows data in a matrix. The matrix includes nested row and column groups, an adjacent column group, and sparklines depict sales by data and subcategory. Pie charts depict sales summary data. Data in one column is rotated 270 degrees..

Prerequisites

Microsoft SQL Server 2008 R2 Reporting Services (SSRS) (Evaluation, Standard, Developer, or Enterprise), or SQL Server 2008 Express with Advanced Services.
Access to Microsoft SQL Server 2008 R2 Report Builder 3.0. You can run Report Builder by using the stand-alone version of Report Builder or the ClickOnce version, available from Report Manager or a SharePoint site. Only the first step, how to open Report Builder, is different for ClickOnce versions.
To use Report Manager, open Report Manager and click Report Builder. By default, the URL for Report Manager is http://<servername>/reports.
To use a SharePoint site, navigate to the site, click the Documents tab, click New Document, and from the drop-down list, click Report Builder Report. For example, http://<servername>/sites/mySite/reports. The SharePoint administrator must enable the Report Builder Report feature for each document library.

Your system must meet the following requirements to use the sample reports.

Server

  • Microsoft SQL Server 2008 R2 Reporting Services (SSRS) (Evaluation, Standard, Developer, or Enterprise), or SQL Server 2008 Express with Advanced Services. Reporting Services can be installed in native or SharePoint integrated mode.
  • Microsoft SQL Server 2008 R2 Database Engine.

Client

Report Builder 3.0 ClickOnce is installed with Reporting Services. Or you can install and use the stand-alone version of Report Builder from Download Center.

Installing Samples

The Reporting Services 2008 R2 samples must be downloaded and installed before you can view or work with them. The download installs the sample reports to the file system on your computer.
Before you can run a sample report successfully, you might need to update the properties of the data source that the report uses. The connection string in the sample reports identifies Localhost as the location of the data source. If no instance of the Database Engine is installed on your computer the report fails. To run the report, you must update the connection string

Update the Data Source

  1. Right -click the data source and click Data Source Properties.
  2. In Connection string, update the name of the data source.
  3. Click OK.

Run a Sample Report in Report Builder 3.0

  1. Open Report Builder 3.0.
  2. In Getting Started, click Open.
  3. Click My Computer and navigate to the folder that contains the sample reports.
  4. Double click the sample report you want to open.
  5. Click Run to preview the report.

Run a Sample Report in Report Manager

Before you can run a sample report in Report Manager, you must upload the file to file to the report server. Alternatively, ask your IT department to make the reports available in Report Manager.

To Upload the Sample Report to Report Manager

  1. Open Report Manager.
  2. Click Upload.
  3. In the SQL Server Reporting Serviced Upload File dialog box, click Browse and locate the sample report.
  4. Click OK.

To Run a Sample Report in Report Manager

  1. Double-click the report.
  2. Optionally, click the Next Page icon to view other pages in the report.

Run a Sample Report in SharePoint

Before you can run a sample report in SharePoint, you must upload the file to file to a SharePoint library. Alternatively, ask your IT department to make the reports available in SharePoint.

To Upload the Sample Report to SharePoint

  1. Open the SharePoint library where you want to run the sample report.
  2. Click Upload.
  3. In the SQL Server Reporting Serviced Upload File dialog box, click Browse and locate the sample report.
  4. Click OK.

To Run the Sample Report in SharePoint

  1. Double-click the report.
  2. Optionally, click the Next Page icon to view other pages in the report.

Tasks

Tutorials (Report Builder 3.0).

Help and Information

© 2010 Microsoft Corporation. All rights reserved.

Last edited May 28, 2010 at 5:47 PM by mariwill, version 1

Comments

VijayReports Jun 9, 2010 at 4:06 PM 
For issues/questions regarding this Report Builder 3 sample, where I enjoyed working with Mariwill and her team, feel free to reach me.