Export (0) Print
Expand All

Reporting Services Sample Reports

SQL Server 2000

The Reporting Services sample reports are a set of predefined report definition files that use the AdventureWorks2000 OLTP database or the Foodmart Analysis Services database as data source. You can upload and view each report separately; however, some reports are designed to work together through the use of links. You can use the sample reports in two ways: to familiarize yourself with the capabilities of Reporting Services, or as templates for designing new reports.

System Requirements

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

Server
  • Microsoft® SQL Server™ 2000 Reporting Services
  • SQL Server 2000 with the AdventureWorks2000 OLTP database installed (for AdventureWorks reports)
  • Analysis Services 2000 with Foodmart database installed (for Foodmart report)
Client
  • Microsoft Internet Explorer 5.0 or later
  • Microsoft Visual Studio® .NET with Report Designer installed (optional)

Installing the Sample Reports

To upload the sample reports, you must first install them on your hard drive by using Reporting Services Setup. When installed using the default location, Reporting Services sample reports are installed in the Samples\Reports folder within the Reporting Services program folder (for example, C:\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Reports). The reports are not automatically deployed to the report server. You do this manually by uploading reports using Report Manager, running a script, or publishing the reports using Report Designer.

Note  Samples are not installed by default. You must choose to install the samples during setup.

The following table describes the sample reports that are provided with Reporting Services.

Report Description
Company Sales Adventure Works Cycles sales by quarter and product category. This report illustrates the use of a matrix data region that provides drilldown from summary data into detail data by showing and hiding rows. This report also illustrates the use of background images.
Employee Sales Summary Adventure Works Cycles sales for an individual employee. This report includes Sales Comparison and Current Month Sales Comparison charts in addition to a Current Month Order Summary table with drillthrough to individual orders. This report illustrates the use of multiple datasets, charts, tables, drillthrough, and dynamic parameters.
Product Catalog The Adventure Works Cycles full product catalog with pictures. This report illustrates the use of embedded images, database images, page breaks, page footers, tables, conditional formatting, and a document map.
Sales Order Detail Detail of an individual Adventure Works Cycles order. This report can be accessed as a drillthrough report from the Employee Sales Summary and Territory Sales drilldown report. This report illustrates the use of lists, tables, parameters, and expressions.
Territory Sales Adventure Works Cycles sales by territory. This report drills down through salesperson and order number with drillthrough to individual orders. This report illustrates the use of a table data region that provides drilldown from summary data into detail data by showing and hiding rows. This report also illustrates the use of drillthrough links and conditional formatting.
Foodmart Sales Foodmart sales by quarter and product department. This report illustrates the use of an Analysis Services data source. It also illustrates matrix, parameters, filters, calculated fields, and drilldown from summary data into detail data by showing and hiding rows.

Uploading Sample Reports Using Report Manager

To make the sample reports available for viewing in a Web browser, you must upload the reports to the report server. You can use Report Manager to upload the report definition files. Before uploading reports, you must first create a shared data source for the reports.

Note  To create a data source and upload files to a folder on the report server, you must have permissions to manage reports for the folder. If My Reports is enabled, you automatically have these permissions for your My Reports folder. For more information, see Managing My Reports.

To upload sample reports using Report Manager

  1. To run the application, type its URL in the address bar of a Web browser. By default, the URL is http://<webservername>/reports.
  2. Navigate to the destination folder for uploaded reports. For more information, see Navigating Folders in Report Manager.
  3. Click New Data Source, and then do the following:
    1. In Name, type AdventureWorks. The sample reports reference the data source by this name.
    2. In Description, type a description or leave the field blank.
    3. Select Enable this data source.
    4. From Connection Type, select Microsoft SQL Server.
    5. In Connection String, provide the connection string to the database that contains the AdventureWorks2000 database. An example of the connection string for a local AdventureWorks2000 database is as follows.
      data source="(local)";persist security info=False;initial catalog=AdventureWorks2000
      
    6. From Connect Using, select Windows NT Integrated Security.
  4. Click OK to save the data source and return to the folder view.
  5. Click Upload File, and then click Browse to navigate to the folder that contains the sample reports.
  6. Click the file to upload, and then click Open.
  7. Click OK to open the file.
  8. Repeat steps 5 through 7 for the remaining sample reports.

Uploading Sample Reports Using Report Designer

You can use Report Designer to upload report definition files to the report server. The sample reports and the AdventureWorks shared data source are included in the report project file. When you publish the reports, the shared data source and the reports are published to the report server.

To upload sample reports using Report Designer

  1. To run the application, click Start, point to Programs, point to Microsoft Visual Studio .NET 2003, and then click Microsoft Visual Studio .NET 2003.
  2. On the File menu, point to Open, and then click Project.
  3. Navigate to the folder to which the sample reports were installed. For information about this location, see "Installing the Sample Reports" earlier in this topic.
  4. Click SampleReports.rptproj, and then click Open.
  5. 2.On the Visual Studio standard toolbar, select the Production solution configuration. (The default configuration is Debug.)
  6. Publish the reports. On the Debug menu, click Start.

    Note  The sample report project is set to publish reports to the report server on the local computer. For information about changing the target server, see Debugging and Publishing Reports.

  7. When publishing is complete, Report Designer opens Internet Explorer. Click a report name to view the report.

Uploading Sample Reports Using a Script

You can also upload reports using a the rs script utility and a sample script. The script creates a folder, adds a data source, and uploads each sample report. For information about using a script to upload reports, see Script for Publishing Sample Reports.

Using the Sample Reports

You can view the sample reports in a Web browser or edit them in Report Designer.

Note  Before you run the reports, ensure that the AdventureWorks2000 OLTP database and Foodmart Analysis Services database are available to the reports. For information about the AdventureWorks2000 database, see AdventureWorks Sample Database. For information about Analysis Services, see SQL Server 2000 Books Online.

To view sample reports using Report Manager

  1. To run the application, type its URL in the address bar of a Web browser. By default, the URL is http://<webservername>/reports.
  2. Navigate to the folder that contains the reports. For more information, see Navigating Folders and Reports.
  3. Click the name of the report that you want to view to open it.

To edit sample reports using Report Designer

  • Open Report Designer, and then open the SampleReports.sln file from the folder containing the sample reports. For more information about working with reports and report projects, see Building Reports.

    Note  The SampleReports.sln solution file contains two solution configurations: Debug and Production. This differs slightly from configurations in newly created report projects. In the sample reports solution, you can use the Debug configuration to preview reports locally, and the Production configuration to publish reports to the report server. For information about the default configurations for new report projects, see Debugging and Publishing Reports.

See Also

Walkthroughs

Installing Reporting Services

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft